View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Sirritys
 
Posts: n/a
Default Huge differences in chart values screws my bar chart scale up.

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