Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
|
|||
|
|||
Answer: bar graph: how do you insert a break in scale (squigglly line)?
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the scale major unit in a graph | Excel Discussion (Misc queries) | |||
on a scatter graph, how do i insert a line indicating the mean? | Charts and Charting in Excel | |||
Custom Line Graph on 2 axes help | Charts and Charting in Excel | |||
Challenging Charting | Charts and Charting in Excel | |||
Can you have a vertical line graph in Excel 2003 | Charts and Charting in Excel |