Forum Discussion
Nathan1123130
Apr 09, 2022Copper Contributor
How to set multiple series labels at once
Hello, I have a scatter plot with 72 series' at the same time. Currently, they are called by default names "Series1", "Series2", etc. But I have a list of labels that I want to set the Series' na...
- Apr 09, 2022
If the range containing the series names is adjacent to the series values, try the following:
- Click anywhere in the chart.
- On the Chart Design tab of the ribbon, in the Data group, click Select Data.
- Click in the 'Chart data range' box.
- Select the range containing both the series names and the series values.
- Click OK.
If this doesn't work, press Ctrl+Z to undo the change.
HansVogelaar
Apr 09, 2022MVP
If the range containing the series names is adjacent to the series values, try the following:
- Click anywhere in the chart.
- On the Chart Design tab of the ribbon, in the Data group, click Select Data.
- Click in the 'Chart data range' box.
- Select the range containing both the series names and the series values.
- Click OK.
If this doesn't work, press Ctrl+Z to undo the change.
- Nathan1123130Apr 09, 2022Copper ContributorAlright, this did work for me