Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / August 2003

Tip: Looking for answers? Try searching our database.

Discontinuous Scales in Excel 2000 Charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nathan Holmes - 27 Aug 2003 17:21 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.