Charts

[Louise]

Hi all

I have a basic column chart with the Value Axis going
from 0 to 100, however, I want the chart to
be 'inverted', ie. if the 'score' for one of the columns
is 5, it is high, and if the score is 90, it is low. In
other words, the lower the number, the better it is.

Any ideas how I can do this?

THanks.

Louise

 

[Andy Pope]

Hi Louise,

Double click the y axis and on the scale tab check both 'Values in
reverse order' and 'Category (x) axis crosses at maximum'

Cheers
Andy

 

[Louise]

Thanks very much. I'd tried one or the other but not
both.

Worked a treat.

Thanks.

Louise