| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I "break" the bar in a graph if a series is off the chart
In a bar graph where all of the data series are of comparable magnitude
except for one which is off the scale, it is useful to show a "break" in the off-the-chart bar so that you can adjust the Y axis scale to fit the other series more appropriately. I'm trying to find out whether it's possible to show this "break" in Excel. Grateful for any insights. |
|
#2
|
|||
|
|||
|
Hi,
It's not a built-in feature back your can mimic it. Here are some examples. http://peltiertech.com/Excel/Charts/BrokenYAxis.html http://tushar-mehta.com/excel/newsgr...tutorial/index... http://andypope.info/charts/brokencolumn.htm Cheers Andy Eddy wrote: In a bar graph where all of the data series are of comparable magnitude except for one which is off the scale, it is useful to show a "break" in the off-the-chart bar so that you can adjust the Y axis scale to fit the other series more appropriately. I'm trying to find out whether it's possible to show this "break" in Excel. Grateful for any insights. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| series graph -- one series being added to another series | Charts and Charting in Excel | |||
| HELP- Copying a Data Series to Another Graph??? | Excel Discussion (Misc queries) | |||
| How do I add a second axis to a graph with 2 data series? | Charts and Charting in Excel | |||
| how do I change the data series an an excel graph | Charts and Charting in Excel | |||
| How to break up a column in a bar graph if I do not want to chang. | Charts and Charting in Excel | |||
Linear Mode
