VBA How to use the InputBox to create charts

How do you use the InputBox to set ranges for charts?

For example, to create a chart, I use:

Please Login or Register  to view this content.

This code lets you select a range of cells to highlight yellow:
https://www.thespreadsheetguru.com/s...with-inputbox/

Please Login or Register  to view this content.

And this code lets you select the chart source data for the active chart:
https://peltiertech.com/assign-chart...ries-with-vba/

Please Login or Register  to view this content.

How would you build the create chart macro with the InputBox? So that you can select:

Please Login or Register  to view this content.

Thank you very much!

Please Login or Register  to view this content.

Just as information. You can use your mouse to select the range with the code from protonLeah.

Wow! Awesome!

Selecting a range for the chart area works the same way:

Please Login or Register  to view this content.

So now, two InputBoxes appear one after another:

1. "Enter data range"
2. "Enter chart range"

You can select the data range as well as the chart range using the mouse.

Wow!

Selecting a range with the series name does not seem to work the same way:

Please Login or Register  to view this content.

A third InputBox appears right after the first two, yes. You can select a range, yes. But somehow it is not being "saved".

To set the series name to a cell reference I use:

Please Login or Register  to view this content.

https://www.excelforum.com/excel-pro...ml#post5937293

And to set the chart name I use:

Please Login or Register  to view this content.

This code lets you select a range with the series name:
https://peltiertech.com/assign-chart...ries-with-vba/

Please Login or Register  to view this content.

So I tried:

Please Login or Register  to view this content.

Doesn't work.

I'm trying not to enter the name as text. I'm trying to select a cell range.

Selecting a range for the chart name works the same way as "data range" and "chart range":

Please Login or Register  to view this content.

You get another InputBox to select a cell or range you want to use as the chart name.

Ok. So this works for chart title and chart name:

Please Login or Register  to view this content.

The only thing I can't get to work is the series name:

Please Login or Register  to view this content.