#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default axis break

Is there a way to make a break in the y-axis? For instance if I have three
values 10, 30, and 300 on an bar graph the difference between the 10 and 30
value is not as clear because of the 300 value. If there was an axis break,
say breaking from 50-250 the diff between 10 and 30 would be more obvious.

If there isn't this option somewhere, why in the hell not!? I consider this
a major oversight in excel.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default axis break

Follow this link for an explanation of how to do it:

http://www.andypope.info/charts/brokencolumn.htm

Andy also links to other sites with similar solutions.

Hope this helps.

Pete

On Oct 30, 10:52 pm, biowonk
wrote:
Is there a way to make a break in the y-axis? For instance if I have three
values 10, 30, and 300 on an bar graph the difference between the 10 and 30
value is not as clear because of the 300 value. If there was an axis break,
say breaking from 50-250 the diff between 10 and 30 would be more obvious.

If there isn't this option somewhere, why in the hell not!? I consider this
a major oversight in excel.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I break the y axis in a chart mrpewty Charts and Charting in Excel 3 March 11th 09 02:20 AM
Excel Axis Break Neil Pearce Excel Discussion (Misc queries) 1 May 7th 07 08:07 PM
Break in Y axis Rave Charts and Charting in Excel 3 November 14th 06 01:54 PM
y-axis break sarah Excel Discussion (Misc queries) 0 February 14th 06 05:51 PM
X axis break Raj Excel Worksheet Functions 0 November 10th 05 09:28 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"