How to Rename Data Series title Automatically Not Manually On MS Excel

[Map Designer]

Hello guys,
I have question in the image below

If I wanted to automatically change Series Name
instead of Series 1, series 2, series 3
to
25, 50, 100, etc, as in the top row (above the data)

how do I do that?

on Microsoft site, I only saw how to change the title of each series manually.

 

[Avatars Lord]

First add one manually, then drag the boxes according to the data.

 

[Map Designer]

yes I just realised it had to be text for it to be title. if it was a number or something, it cannot be used as series title.

edit: what happened to the pic i uploaded? lol

 

[Avatars Lord]

yes I just realised it had to be text for it to be title. if it was a number or something, it cannot be used as series title.

edit: what happened to the pic i uploaded? lol

Did you try to convert them as a text?

 

[Map Designer]

Did you try to convert them as a text?

View attachment 344171

if you are talking about the formatm, yes I did and it didnt work (with me).

what worked though, is that I make the title as text, then make the data series, and then change the title unto number. that way it will still be considered a title for the scatter lines.