Grouping Y values in a bar chart
The chart shown in
Figure 16‑14 groups Y values to plot multiple sets of bars representing the monthly sum of orders for three types of vehicles.
Figure 16‑14 Bar chart that plots multiple sets of bars by grouping
Figure 16‑15 shows the axes and grouping definitions used to create this chart.
Build the expressions shown in
Table 16‑4 by dragging columns from the data preview and dropping them in the three areas shown in Figure 16‑15.
Table 16‑4 Definitions of series in bar chart that uses grouping
Series | Expression |
Value (Y) Series | row["QUANTITYORDERED"] |
Category (X) Series | row["ORDERDATE"] |
Optional Y Series Grouping | row["PRODUCTLINE"] |