Forum Discussion

Nathan1123130's avatar
Nathan1123130
Copper Contributor
Apr 09, 2022
Solved

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...
  • HansVogelaar's avatar
    Apr 09, 2022

    Nathan1123130 

    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.

Resources