Discontinuous Scales in Excel 2000 Charts

[Nathan Holmes]

I have a chart in which the majority of the values are in
the range 0-10, but a couple are around 100. (The chart
might be a bar chart or line graph depending on the end
users' eventual preference.)

Setting the scale to include the large values makes
variations in the smaller entries difficult to see. I
don't fancy my chances of explaining a Log scale to the
intended audience. Is it possible to have discontinuous
axes (e.g.: 0-20,BREAK,90-110) on a chart in Excel 2000,
or do I need to look at more specialist charting tools?

Thanks for any help,

Nathan Holmes.

 

[dvt]

Is it possible to have discontinuous
axes (e.g.: 0-20,BREAK,90-110) on a chart in Excel 2000,
or do I need to look at more specialist charting tools?

Specialist charting tools will work, but Tushar Mehta and Jon Peltier
provide workarounds for Excel. See:

www.tushar-mehta.com, broken y axis
http://www.geocities.com/jonpeltier/Excel/Charts/BrokenYAxis.html

Dave
dvt at psu dot edu

 

[nathan holmes]

Thanks for the links. I wouldn't want to have to go
through that process too often, but it's ideal for the
case at hand.

Nathan.