Help - Best way to show this type of data in graph.

I have the following information:

Month
Total
Opened
Closed

I have attached an example of the data and chart.

Obviously the Total data is far superior to the Opened and Closed numbers.
I dont want the open and closed numbers to look non existent in the chart.

Is there anyway to split the Y axis so that it shows an average of the numbers (say 1400 - 1800) and then an average of the opened and closed (say 0 to 30) at the bottom?

If not, does anyone else have any suggestions on how to better show this data in the one chart?

Thanks

McCrimmon

Hi,

How about a simple dimension change, like Total / 100 and then grahp that. See attached.

Originally Posted by MarvinP

Hi,

How about a simple dimension change, like Total / 100 and then grahp that. See attached.

Thanks for the input.
Whilst, it works and looks good, I think I need to keep the numbers full if possible....

Theres every chance that what im after is impossible, hence the reason for asking the question.

Thanks again though. Appreciated.

Andy Pope is the graphing expert and looking at his site at
http://www.andypope.info/charts.htm
I just don't see what you are looking for.

Either break the Y axis,
http://www.andypope.info/charts/brokencolumn.htm

Or move the Open/Close information on to the secondary axis. You will need to add 3 dummy series in order to keep the columns from covering each other.