Chart series governed by cell entry

[Kauri]

Hello, Hope your weekend is going to be good.
Does anyone know if it is possible to change the series in a chart by using cells rather than going to the chart format options?
In other words if I wanted a crossover, say 3 and 20, I could enter the numbers in 2 separate cells and have them relate to the chart format.
I hope this is making sense and appreciate if you read this.

 

[awoohaw]

I don't understand. Maybe you can post your data, and what your before and after images should look like?

 

[Kauri]

Hello, Thank you for your reply. I have attached the file and hope it explains better.

 

[awoohaw]

I cannot read what you're attempting. There is no data as I asked (if there is, it is illegible). I still do not understand how you want to use the variable you discuss.
The images are way to small. Please post your data using xl2bb add in (link below) or post the data as a table so it can be copied and then pasted.

Please help the forum help you.

 

[NdNoviceHlp]

Hi *Kauri. It seems like you are trying to chart different sections of your chart data. For a VBA solution see Jon Peltier's code at the following link. HTH. Dave

Macro to move chart data series reference down one row for all charts and all series in workbook.

Hi guys I have a number of line charts, some with one series some with multiple. There are around 70 of these charts which plot a variable over the past year from table on another worksheet. The table has months down the columns with a value for each location of the variable. See attached. Just...

www.mrexcel.com

 

[Kauri]

Hello NdNoviceHlp and awoohaw,
Thank you very much.
Works perfectly, appreciate the help.
Happy coding ☺

 

[NdNoviceHlp]

You are welcome. Thanks for posting your outcome. Thanks also to Jon Peltier for his time and excellent code at the link. Dave