For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #64

In this alternative to an Excel stacked column chart, individual values are easy to track and compare by period. And the total value is plotted as a line associated with the right axis.


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

An Improvement on Excel Stacked Column ChartsThe top chart is a standard stacked column chart. And the bottom chart provides a useful alternative.

The top chart offers one primary advantage: We can use one scale to see both the individual values and the total values by period.

However, the problem with all stacked-column charts is that we canít easily track the trends for each item (here, each state) or compare the relative performance of their individual values by period.

To illustrate, looking only at the top chart, which state had a higher GDP? South Dakota in 2005 or North Dakota in 2007?

Thatís why I created the second chart. In this chart, the individual values are easy to track and compare by period. But the total value is plotted as a line associated with the right axis.

(Continued in the documentation.)

Order Details

Excel Versions:

Excel 2007 and after, for either Windows or Mac

Availability:

Instant download of zipped Excel and PDF files. If you ever need another download, you can get it at any time.

Guarantee:

One full year, unconditional.

Currency:

All prices are in US Dollar currency.

Licensing:

Two copies: One for work plus one for home.

Credit Cards:

Credit Cards
 

Only $12.95

New Excel