Discontinuous Scales in Excel 2000 Charts

  • Thread starter Thread starter Nathan Holmes
  • Start date Start date
N

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.
 
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.
 
Back
Top