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/newsgr...ial/index.html
http://www.andypope.info/charts/brokencolumn.htm
Cheers
Andy
Sirritys wrote:
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, Microsoft MVP - Excel
http://www.andypope.info