Changing a charts series order

C

Csmith

In eariler version of excel I was able to rearrange the series order of my
charts. This allowed me to view data that existed under multiple data series.
How do I change the series order?

Additionally, how do I change the order of the series included in the legend?
 
A

Andy Pope

Hi,

You can change the series order via the select data dialog.
Select chart, Chart Tools > Design > Data > Select Data

The order of the items in the legend will change automatically.

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

Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
How to change series plotting order without changing legend order? 6
Convert Error Bars to Series and Colour 1
How do I find the series associated with a given legend entry. 4
For chart syles, why doesn't color order match series order? 1
Data points in chart incorrect 0
How to change the series order in a LEGEND ONLY...not data 2
Overlay line graph points on bar graph 1

Top