Reverse values but not X axis

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Hi,

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

Cheers
Andy
 
Thanks Andy... I didnt even think to try (stressed!)
Thanks heaps.
cheers,
Nadia
 
You must log in or register to reply here.

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
Make Y-axis values correspond to x- axis value 1
X-axis in 2007 4
Formatting 'X' Axis -- 2 fundamental differences 7
Chart problems 1
value of y axis position 2
One extra x axis item that wont go away - can anyone help? 3

Back
Top