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

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

Thanks