Column charts sort the given hierarchies and measures into columns, with the hierarchy's member elements on the x-axis, and the measure on the y-axis. A column chart must contain at least 1 member hierarchy and 1 measure. Member hierarchies can be added to the Categories or Color drop zones, and measures to the values zone.
- On the ribbon, click the Components tab to see Chart Design .
Build a Column Chart
Start by adding a member hierarchy to the Categories zone.
Add the required measure to the Values zone.
If you want to add a color dimension to the chart, move the hierarchy to Color.
Add a Second Hierarchy
Alternatively, add a second hierarchy to Color:
Another option is to add a measure to Color; this may be the measure in the Values zone, or a different measure.