Column charts work best where data points are limited (i.e. 12 months, 4 quarters, etc.). With more data points, you can switch to a line graph.


Easy to read Simple and versatile Easy to add data labels at ends of bars


Become cluttered with too many categories Clustered column charts can be difficult to interpret


Add data labels where when it makes sense Avoid all 3d variants


Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Column chart - 54Column chart - 96Column chart - 63Column chart - 10Column chart - 30Column chart - 53Column chart - 87Column chart - 98Column chart - 37