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.

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.

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.