Changing a charts series order

G

Guest

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

How to change series plotting order without changing legend order? 6
How do I find the series associated with a given legend entry. 4
How to change the series order in a LEGEND ONLY...not data 1
For chart syles, why doesn't color order match series order? 1
User Selectable Series and Number of Series for Line Chart 2
how to select multiple data series in a chart? 1
chart legend changing when I use Select data 1
Change series order in a legend 2

Top