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 - 27 Aug 2003 18:16 GMT
> 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 - 28 Aug 2003 12:14 GMT
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.