What is the way to change the series order in Microsoft Excel 2007
I need help to change the actual series order in legend in Excel. I tried to figure out some steps from the help file, but that does not really worked more. It shows some limitation in the order.
Re: What is the way to change the series order in Microsoft Excel 2007
This are the steps which can help you for the process.
- Right-click in the whiote-space.
- Select Source Data
- Go to Series Tab
- Assign your names and data from here so that your desired first series is in the top spot. However, changing the order in the select data source dialogue box did not change the displayed order
Re: What is the way to change the series order in Microsoft Excel 2007
There is detailed step mentioned below. You can see the link and try to modify the same following the steps. On the right side you can see more options to play with the chart settings.
Modify chart legend entries