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 in 3-D charts with a third axis. You cannot reverse the plotting order of values in a radar chart.

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

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

  3. 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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×