Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Zach
 
Posts: n/a
Default bar graph: how do you insert a break in scale (squigglly line)?

With a wide data range or one number that is much larger than others in a
series, how can one insert a break in the scale, often represented by 2
squiggly lines?

Thanks!
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: bar graph: how do you insert a break in scale (squigglly line)?

  1. 1. Create your bar graph by selecting your data and clicking on the "Insert" tab in the Excel ribbon. Choose the type of bar graph you want to create.
    2. Select the vertical axis to bring up the "Format Axis" pane on the right-hand side of the screen.
    3. Scroll down until you see the "Axis Options" section. Look for the "Breaks" option and click on the drop-down menu next to it.
    4. Choose the type of break you want to insert. In this case, you want to insert a "Custom" break, so select that option.
    5. Enter the values you want to use for the "Minimum bound" and "Maximum bound". For example, if your data range is from 0 to 1000, you might want to set the minimum bound to 0 and the maximum bound to 500.
    6. Choose the type of squiggly line you want to use by clicking on the drop-down menu next to "Break shape".
    7. Adjust any other formatting options you want to use for your graph, such as colors, labels, and titles.

That's it! Your bar graph should now have a break in the scale represented by two squiggly lines. This can be very helpful when you have a wide data range or one number that is much larger than others in a series.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default bar graph: how do you insert a break in scale (squigglly line)?

Hi,

Here are some examples of how to produce a broken axis effect.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/excel/newsgr...ial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

Zach wrote:
With a wide data range or one number that is much larger than others in a
series, how can one insert a break in the scale, often represented by 2
squiggly lines?

Thanks!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
Changing the scale major unit in a graph Ant Excel Discussion (Misc queries) 2 February 6th 06 02:42 PM
on a scatter graph, how do i insert a line indicating the mean? caro Charts and Charting in Excel 1 November 14th 05 01:19 PM
Custom Line Graph on 2 axes help nevs Charts and Charting in Excel 4 October 27th 05 03:29 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
Can you have a vertical line graph in Excel 2003 smithers2002 Charts and Charting in Excel 3 January 12th 05 02:27 PM


All times are GMT +1. The time now is 07:21 PM.

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

About Us

"It's about Microsoft Excel"