Split large bar in a graph?
In MS Graph, I have a bar chart in which one of the values is much larger
than all the other ones. As a result, all you can see on the chart is this very tall bar and all the other ones are very small. Is there any way I can split this large bar in the middle to show it's not on the same scale and make the other ones appear larger? Thank you |
Hi,
Jon has an example, which includes a couple of links to alternative solutions. http://peltiertech.com/Excel/Charts/BrokenYAxis.html Cheers Andy Neronimo wrote: In MS Graph, I have a bar chart in which one of the values is much larger than all the other ones. As a result, all you can see on the chart is this very tall bar and all the other ones are very small. Is there any way I can split this large bar in the middle to show it's not on the same scale and make the other ones appear larger? Thank you -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
I don't think MSGraph allows the kind of flexibility with extra series that Excel
does. (I tried a few of these approaches in MSG in the past, with very limited success.) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Andy Pope wrote: Hi, Jon has an example, which includes a couple of links to alternative solutions. http://peltiertech.com/Excel/Charts/BrokenYAxis.html Cheers Andy Neronimo wrote: In MS Graph, I have a bar chart in which one of the values is much larger than all the other ones. As a result, all you can see on the chart is this very tall bar and all the other ones are very small. Is there any way I can split this large bar in the middle to show it's not on the same scale and make the other ones appear larger? Thank you |
Hi Jon,
Yeah I know MS Graph is not the most flexible thing, but it can be done. http://www.andypope.info/ngs/ng30.htm Cheers Andy Jon Peltier wrote: I don't think MSGraph allows the kind of flexibility with extra series that Excel does. (I tried a few of these approaches in MSG in the past, with very limited success.) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Andy Pope wrote: Hi, Jon has an example, which includes a couple of links to alternative solutions. http://peltiertech.com/Excel/Charts/BrokenYAxis.html Cheers Andy Neronimo wrote: In MS Graph, I have a bar chart in which one of the values is much larger than all the other ones. As a result, all you can see on the chart is this very tall bar and all the other ones are very small. Is there any way I can split this large bar in the middle to show it's not on the same scale and make the other ones appear larger? Thank you -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Very nice.
- Jon Andy Pope wrote: Hi Jon, Yeah I know MS Graph is not the most flexible thing, but it can be done. http://www.andypope.info/ngs/ng30.htm Cheers Andy Jon Peltier wrote: I don't think MSGraph allows the kind of flexibility with extra series that Excel does. (I tried a few of these approaches in MSG in the past, with very limited success.) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Andy Pope wrote: Hi, Jon has an example, which includes a couple of links to alternative solutions. http://peltiertech.com/Excel/Charts/BrokenYAxis.html Cheers Andy Neronimo wrote: In MS Graph, I have a bar chart in which one of the values is much larger than all the other ones. As a result, all you can see on the chart is this very tall bar and all the other ones are very small. Is there any way I can split this large bar in the middle to show it's not on the same scale and make the other ones appear larger? Thank you |
All times are GMT +1. The time now is 02:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com