A column chart is a primary Excel chart jot down, with data series plotted using vertical columns.

Column charts are a good way to show change over time because it’s easy to compare column lengths.

Column charts work best where data points are limited (i.e.

Dynamic chart example - ignore empty values

12 months, 4 quarters, etc.).

With more data points, you’ve got the option to switch to a line graph.

When a new value is added, the chart automatically expands to include the value.

Excel clustered column chart example

Excel stacked column chart example

Excel 100% stacked column chart example

Excel bar chart example

Excel clustered bar chart example

Excel stacked bar chart example

Excel 100% stacked column bar example