Another Excel graph question

  Tim1964 20:08 29 May 08
Locked

When trying to create a graph using Excel's Graph Wizard, I need the Y axis numbers to go upwards from the origin in decreasing numbers (for e.g 50 to 0) rather than from 0 to the 50.

Basically, is there a way to 'invert' the data series for the Y axis?

Thanks,

  VoG II 20:16 29 May 08

Right click the axis > Format Axis > tick Values in Reverse Order.

  TonyV 20:20 29 May 08

This was from the Help menu in Excel 2000. Maybe it is the same in your version!


"Reverse the plotting order of categories, values, or series
You can reverse the plotting order of categories or values for most charts, as well as of data series for 3-D charts with a third axis. You cannot reverse the plotting order of values in a radar chart.

Click the axis for the categories, values, or series whose plotting order you want to change.


On the Format menu, click Selected Axis, and then click the Scale tab.


To reverse the plotting order of categories, select the Categories in reverse order check box.
To reverse the plotting order of values, select the Values in reverse order check box.

To reverse the plotting order of series for 3-D charts, select the Series in reverse order check box."

Hope this helps.

TonyV

  Tim1964 20:25 29 May 08

Thanks guys,

The MS 'help files' are a bit of an oxymoron. I need a help file just to understand the help files.

:D

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac