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 / June 2007

Tip: Looking for answers? Try searching our database.

Hide part of axis

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sam - 07 Jun 2007 18:51 GMT
I'm creating a line chart with data that is mostly similar (values are around
10,000 each) but then one line of my data is huge (around 14,000,000).  What
I'd like to do is have all of this data on the same chart, but when I do
that, it makes all the 10,000ish data extremely small and close together at
the bottom in order to make room on the chart for the 14,000,000 item on the
x-axis.  Is there a way to make the axis skip from around 20,000 to
13,900,000 for example (an area that would be blank on the chart as it is
now), to be able to show detail for all lines?
David Biddulph - 07 Jun 2007 19:43 GMT
http://peltiertech.com/Excel/Charts/BrokenYAxis.html
Signature

David Biddulph

> I'm creating a line chart with data that is mostly similar (values are
> around
[quoted text clipped - 8 lines]
> 13,900,000 for example (an area that would be blank on the chart as it is
> now), to be able to show detail for all lines?
 
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.