 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2007broken axis bar graph
Hi: I have a bar graph with some really small numbers and then one bar that's very big. Since the smaller bars are always going to be small, I want to create a broken y-axis so it goes from 0-100, then breaks and starts at 1000 and keeps going... I found one post that was good for scatterplots, but since mine is a bar graph, I would appreciate any help out there on the subject. Thanks, M Have a look at this site: http://www.andypope.info/charts/brokencolumn.htm This also includes links to other sites covering the topic. Hope this helps. Pete > Hi: > [quoted text clipped - 9 lines] > > M > Have a look at this site: > [quoted text clipped - 21 lines] > > - Show quoted text - Thanks for this, but how do you get past creating the second x-axis? When I do it, the scale goes 0, 0, 1, 0, 0 (it won't let me change the min/max -in fact, it's treating like it's a text axis or something).... Thanks in advance for any help... I've never tried to do it myself - perhaps Andy/Jon/Mushta will come in sometime ... Pete > > Have a look at this site: > [quoted text clipped - 28 lines] > > - Show quoted text - Hi, I can't quite envisage what you are doing. If you want to email me off NG you data file I will have a look see. Cheers Andy >>Have a look at this site: >> [quoted text clipped - 26 lines] > min/max -in fact, it's treating like it's a text axis or > something).... Thanks in advance for any help...  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Hi Andy, will respond when I can. Sorry for the delay - I appreciate your extending yourself to help... another project just popped up. :( Thanks again, Michelle > Hi, > [quoted text clipped - 42 lines] > > - Show quoted text -
|
Reply to this Message |
 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.