How to present one outstanding data in a chart
 

Hi,

I've got a number of "normal" value columns in a column chart with one
column, that is far higher than all the others. Because of that, the
differences between values of all the other columns become hardly visible,
since the vertical axis becomes so much higher. Is there any way, in Excel
2007 or 2003, to "cut" the axis somewhere in between to correctly show all
the values? I hope you understand what I'm looking for...

Many thanks,

How to present one outstanding data in a chart
 

Sorry, I've just found the answer. It is called "Broken Y axis" and there is
a great article on http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Just in case anybody else looks for that...

"Mare" wrote:

Hi,

I've got a number of "normal" value columns in a column chart with one
column, that is far higher than all the others. Because of that, the
differences between values of all the other columns become hardly visible,
since the vertical axis becomes so much higher. Is there any way, in Excel
2007 or 2003, to "cut" the axis somewhere in between to correctly show all
the values? I hope you understand what I'm looking for...

Many thanks,

How to present one outstanding data in a chart
 

Hi,

Here are some pages on how to fake a broken value axis.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/
http://andypope.info/charts/brokencolumn.htm

Cheers
Andy

Mare wrote:
Hi,

I've got a number of "normal" value columns in a column chart with one
column, that is far higher than all the others. Because of that, the
differences between values of all the other columns become hardly visible,
since the vertical axis becomes so much higher. Is there any way, in Excel
2007 or 2003, to "cut" the axis somewhere in between to correctly show all
the values? I hope you understand what I'm looking for...

Many thanks,