charting help

[njbeancounter]

I have 4 amounts to chart based on daily activity. 3 of the amounts are in the same range, between 20,000,000 and 100,000,000, with major gridlines every 20,000,000. The fourth line is also based on daily activity, but maxes out below 20,000,000. I don't want a secondary axis, as that will confuse the reader.

With that being said, what I want is from 0 to 20,000,000 to have major gridlines every 2,000,000 and from 20,000,000 to 100,000,000 to have major gridlines every 20,000,000.

help?

 

[Steve=True]

This can be done, but takes a lot of work. You are looking for a Broken Y Axis.

However, this may mislead your reader since the bar for one is not truely in proportion to other bars in the same graph if they don't notice the break and number changes.


Steve=True
www.exceldashboardtemplates.com

 

[wigi]

You could follow Andy Pope's workbook:

http://www.andypope.info/charts/brokencolumn.htm

 

[njbeancounter]

thanks to both of you...I will look into the andy pope info...

 

[Jon Peltier]

Broken columns are at least as confusing as dual axes. Your best bet is two charts each with their own scales, or perhaps a panel chart, as in Panel Charts with Different Scales.