| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Reverse values but not X axis
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 |
|
#2
|
|||
|
|||
|
Hi,
As well as ticking "Values in Reverse Order" also tick "Category (x) axis crosses at Maximum value" Cheers Andy Nadia wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
Thanks Andy... I didnt even think to try (stressed!)
Thanks heaps. cheers, Nadia "Andy Pope" wrote: Hi, As well as ticking "Values in Reverse Order" also tick "Category (x) axis crosses at Maximum value" Cheers Andy Nadia wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Axis Scale Auto Values | Charts and Charting in Excel | |||
| Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
| interchangine catergory and values axis | Charts and Charting in Excel | |||
| catergory on the X axis; values on the Y axis | Charts and Charting in Excel | |||
| how to paste the values in reverse order in workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
