Column charts use vertical bars to show comparison between categories or things. One axis displays the categories being compared, the other, the data values. They are effective for showing the situation at a point in time. If something can be counted, it can be represented in a column chart, for example, the number of products sold or hits on a website.
Column charts are effective for emphasizing the difference between values. Used to compare change between groups over time, column charts are easiest to read when the differences in data value are relatively large.
If you have many categories to compare, a line graph might be easier to read.
Column charts can be created in standard, stacked, or percentage formats. Each format displays the same data in a different way, making it easier to make comparisons or see patterns emerging in the data. The method for creating standard, stacked and percentages charts is the same, regardless of the output.
Which Chart? discusses the different chart types and which type is best for particular purposes.
Stacked column charts
Stacked column charts use vertical bars, divided into sub-parts. These show the cumulative values of a data item, and compare the parts to the whole. Items stacked on top of one another are differentiated by color.
They show the component parts of each element being examined, integrating different data sets to create a richer picture of the sum of changes. They can show change over time and are particularly useful when comparing relative and absolute differences — where the sum of the values is as important as the totals.
A stacked chart is useful for looking at changes in, for example, expenditure over time across several products or services.
A stacked column chart with aggregated values as numbers:
Percentage column charts
Percentage column charts are the same as stacked charts but show values as a percentage meaning that all the bars are the same length. You can use them in the same way as stacked charts and they are particularly useful when comparing relative differences.
A percentage column chart with aggregated values as a percentage:
Create a Standard Column Chart
- Highlight a range of cells in a grid.
- Click the Chart button on the Anaplan Toolbar and select Column Chart. The Chart Options dialog displays:
- Choose appropriate values in Chart Options.
- Click Publish to Dashboard and select a target dashboard.
Create a Stacked or Percentage Column Chart
Stacked and Percentage column charts are created in exactly the same way as a basic Column chart. Select Column - Stacked or Column - Percentage from the options displayed when you click the Chart button on the Anaplan Toolbar.