Showing posts with label excel secondary axis. Show all posts
Showing posts with label excel secondary axis. Show all posts

Saturday, March 3, 2012

Add secondary axis to chart

If your graph has 2 columns with numeric data and looks like below chart.

The above chart is difficult to analyze, because the scale of the Transactions is much larger than the scale of the Units Sold. As a result, we can barely read the Units Sold series and can’t gain any useful insight from the virtually indistinguishable columns. The Total Transactions should be moved to a secondary axis, allowing the series to be scaled differently.