Huge differences in chart values screws my bar chart scale up.

[Sirritys]

Hi!

I have a table which has mainly values between 0 and 5000 and I made
bar chart from that data.

Then I have 1 value which is over 100 000. This ofcourse makes all
other bars way to small to be of any use.

Is there any way to "truncate" this 1 bar so it wouldn't mess up the
scale, but would show the right value anyway? Could I for example set
different scale from 0 to 5000 and then from 5000 to 120 000?

Regards,
Aki

 

[Andy Pope]

Hi,

Have a look at these examples of how to place a break in the Y axis.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/excel/newsgroups/broken_y_axis/tutorial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

 

[Sirritys]

Thanks