Reverse values but not X axis

G

Guest

I am trying to create a chart showing staff performance reviews where 1 is
the highest value and 5 is the lowest (based on our rating system). Obviously
excel creates the axis with values from 0 to 5. If I reverse values it
basically flips the chart upside down with the X axis above.

Is there a way to reverse values only?

Many thanks in advance.
Nadia
 
A

Andy Pope

Hi,

As well as ticking "Values in Reverse Order" also tick "Category (x)
axis crosses at Maximum value"

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Positioning x axis at bottom of chart with negative values 5
Primary X axis to Secondary X axis 1
X-axis in 2007 4
Reverse y-axis, with maximum number at x-axis 1
One extra x axis item that wont go away - can anyone help? 3
Make Y-axis values correspond to x- axis value 1
Secondary axis not aligning to X axis 1
Chart problems 1

Top