
Once you see data in a chart, you may find there are some tweaks and changes that need to be made. Here are a few ways to change the data in your chart.
Add a Data Series
If you need to add additional data from the spreadsheet to the chart after it’s created, you can adjust the source data area.
- Select the chart.
- In the worksheet, click a sizing handle for the source data and drag it to include the additional data.
The new data needs to be in cells adjacent to the existing chart data.
Rename a Data Series
Charts are not completely tied to the source data. You can change the name and values of a data series without changing the data in the worksheet.
- Select the chart
- Click the Design tab.
- Click the Select Data button.
- Select the series you want to change under Legend Entries (Series).
- Click the Edit button.
- Type the label you want to use for the series in the Series name field.
- Click OK.
- Click OK again.
The name is updated in the chart, but the worksheet data remains unchanged.
Reorder a Data Series
You can also change the order of data in the chart without changing the order of the source data.
- Select the chart
- Click the Design tab.
- Click the Select Data button.
- From the Select Data Source dialog box, select the data series you want to move.
- Click the Move Up or Move down button.
- Click OK.
The chart is updated to display the new order of data, but the worksheet data remains unchanged.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.