Like clustered column charts, clustered bar charts become visually complex as the number of categories or data series increase. They work best in situations where data points are limited.
Pros
Allow direct comparison of multiple data series per category Can show change over time
Cons
More difficult to compare a single series across categories Become visually complex as categories or series are added
Tips
Limit data series and categories Avoid all 3d variants
…Read more Author
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.
