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 / January 2004

Tip: Looking for answers? Try searching our database.

Making a bar chart "broken" for large data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tyler - 26 Jan 2004 14:35 GMT
I have a bar chart I am making in which one series of data
is much larger than the others (say 30,000 units versus
1,000 units). When I chart it I get one very long bar for
the 30,000 units and a buch of small bars for the other
series.

I'd like to "break" the y-axis scale so that the 30,000
unit series is still shown but is not out of line with the
others. It is a change in the graphical represnetation of
the data, but I've looked in Help but can't seem to find
this feature.

It is hard to describe in text, but I've seen it done
quite often in publication. Just not sure how to pull it
off in Excel.

Thanks
-Tyler
Andy Pope - 26 Jan 2004 14:55 GMT
Hi Tyler,

Take a look at Jon's example.
(http://peltiertech.com/Excel/Charts/BrokenYAxis.html)

which also includes links to examples on both Tushar Mehta's and my own
site.

> I have a bar chart I am making in which one series of data
> is much larger than the others (say 30,000 units versus
[quoted text clipped - 14 lines]
> Thanks
> -Tyler

Signature

Cheers
Andy

http://www.andypope.info

Frank Kabel - 26 Jan 2004 14:56 GMT
Hi Tyler
have a look at
http://www.tushar-mehta.com/excel/newsgroups/broken_y_axis/index.html
or
http://peltiertech.com/Excel/Charts/axes.html#Broken

HTH
Frank

> I have a bar chart I am making in which one series of data
> is much larger than the others (say 30,000 units versus
[quoted text clipped - 14 lines]
> Thanks
> -Tyler
 
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.