'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Chart Legend Order Not Matching Data Order
Question details
The user is trying to correct the legend order in an Excel scatter chart that does not reflect the actual source data or intended series order.
- Product
- Spreadsheet
- Device & OS
- not provided
- Scenario
- Creating or formatting a scatter chart and attempting to organize the legend entries logically.
- Observed behavior
- Legend items are displayed in an unexpected sequence, ignoring manual changes made to the source data range.
Verify that your chart is a standard chart and not a PivotChart, as PivotChart legends are strictly controlled by the PivotTable's sorting rules. For standard charts, ensure all your source data is complete before modifying the series order.
Reorder Series Using the Select Data Source Dialog
This is the most reliable method to change the legend order without altering your actual worksheet data.
In Excel and WPS Spreadsheet, scatter chart legends are determined by the order in which data series are added to the chart, not necessarily by their physical position in the worksheet cells. Modifying the series order in the chart settings directly forces the legend to update.
Right-click on an empty space within your chart area and choose 'Select Data' from the context menu.
In the 'Select Data Source' dialog box, find the list under 'Legend Entries (Series)' on the left side.
Click on the specific series you want to reposition. Use the 'Move Up' (upward arrow) or 'Move Down' (downward arrow) buttons at the top of the list box to change its position.
Click 'OK' to close the dialog box. Your chart legend will instantly update to reflect the new sequence.
Reverse the Axis Order
Use this method if your bar or column chart legend is in the exact opposite order of what you need.
Easily Customise Chart Legends in WPS Spreadsheet
WPS Spreadsheet provides an intuitive interface to manage complex chart data, adjust legend orders, and visualise data effectively. It is a powerful, free tool that seamlessly handles Microsoft Excel files.
- 1. Open your workbook: Launch WPS Spreadsheet and open the file containing your scatter chart.
- 2. Access Data Settings: Right-click the chart background and click 'Select Data' from the menu.
- 3. Reorder the Series: Select the series in the list and click the Up or Down arrows to arrange your legend.
- 4. Apply and Save: Click 'OK' to apply your new legend order and save your workbook.
Frequently Asked Questions
Why doesn't my scatter chart legend update when I sort my source data?
Scatter charts and some other chart types link their legend order to the sequence in which the series were originally added to the chart. Sorting the physical worksheet rows won't change this internal sequence; you must use the 'Select Data' dialog to rearrange them.
How do I hide a specific item from the chart legend without removing the data?
Click on the chart legend to select it, then click directly on the specific legend entry you wish to remove so that only it is highlighted. Press the Delete key on your keyboard. The data will remain on the chart, but the label will disappear from the legend.
Can I manually drag and drop legend items to reorder them?
No, Excel and WPS Spreadsheet do not support dragging and dropping items directly within the legend box. You must adjust the series order via the 'Select Data Source' menu.
