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. |
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 |
All times are GMT +1. The time now is 08:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com