Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to break up a column in a bar graph if I do not want to chang.
I have a column graph in which one of the columns is much bigger than the
other ones. That masks differences among the smaller columns, so I wanted to know if there is a way to fix the scale to a small value on the Y axis and break up the larger column, so it will still show its top with the error bar. |
#2
|
|||
|
|||
I believe Andy's example will give you what you want . . .
http://www.andypope.info/charts/brokencolumn.htm ---- Regards, John Mansfield http://www.pdbook.com "Krlinhos" wrote: I have a column graph in which one of the columns is much bigger than the other ones. That masks differences among the smaller columns, so I wanted to know if there is a way to fix the scale to a small value on the Y axis and break up the larger column, so it will still show its top with the error bar. |
#3
|
|||
|
|||
Here's another:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ John Mansfield wrote: I believe Andy's example will give you what you want . . . http://www.andypope.info/charts/brokencolumn.htm ---- Regards, John Mansfield http://www.pdbook.com "Krlinhos" wrote: I have a column graph in which one of the columns is much bigger than the other ones. That masks differences among the smaller columns, so I wanted to know if there is a way to fix the scale to a small value on the Y axis and break up the larger column, so it will still show its top with the error bar. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
On a combination chart how do i get 2 lines and 1 column? | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Problem with graph ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |