VBA Assign Chart Series Name

Found this code by Jon Peltier:
https://peltiertech.com/assign-chart...ries-with-vba/
It lets you select a range that contains the series name via InputBox.

Please Login or Register  to view this content.

So I added these lines to my create chart code, hoping it would do. Nothing happened.

Please Login or Register  to view this content.

What am I missing?

Thanks Jon!
Thanks everyone!

You're using the wrong property.

".Name" only RETURNS the name of the chart, not sets it.

You need to use ".FullSeriesCollection(1).Name"

Please Login or Register  to view this content.

Hi Torachan.
Thanks, corrected that, didn't help.

Hi PrizeGotti,
".FullSeriesCollection(1).Name" causes an Automation Error.

Not on my machine, did you copy and paste the code I posted?

Had to restart Excel, now your code works, thanks.
But the red frame is still missing.

In the "Select Data Source" window, the "Name" is still blank/empty:

I've also tried to record a macro, but Excel won't allow that in the "Select Data Source" window, saying "Application.CutCopyMode = False".

Andy, thank you so much!

One thing I've noticed:

If the series name is set as text, the create code creates the chart in a way, that the categories and values are highlighted (blue, purple)

- if you click on the chart area

- if you click on the plot area

- if you click on the slices/bars

If the series name is set as a range (with your code), series name, categories and values are only highlighted (red, blue, purple)

- if you click on the slices/bars

Might there be an "easy fix" to this as well?

Thank you!