Chart sourcedata updating with VBA

Originally Posted by xlbiznes

hi,

please post a sample workbook.

Heya,

I only need to get the ActiveChart.SeriesCollection(x).Values = "=Graph_Data!RSPX" the rspx part to be inserted from a cell data. My cell, in this case "w1" on rsp2_graph sheet contains "$B$5:$B$13" which I want to insert into the bolded area on the code, so it would become "=Graph_Data!$B$5:$B$13", which would in this case work as intended. If I manually replace the string value on the macro to look like
ActiveChart.SeriesCollection(1).Values = "=Graph_Data!$B$5:$B$13" the chart will update to show right values.

This is because the "$B$5:$B$13" part is changed every time I update new data in an other sheet. Thats why I cant just have a chart on static B5:B13 values and I don't want to manually update all the charts every time I update new data in..

If it still doesn't open up I can provide a sample workbook.

Thanks

Originally Posted by xlbiznes

Hi,

Can you try something like this :

Please Login or Register  to view this content.

Heya,

Sorry, this doesn't work for me as I need to input 3 different data into 3 different "data sources", as I got 2 different Y axis and 1 X axis data.

Please Login or Register  to view this content.

The chart template I'm using is "Plotted line with markers" or something.

Thanks

Originally Posted by Jon_Peltier

So "RSPi" is the name of a cell containing an address? The name Graph_Data!RSP1 contains something like "$B$5:$B$13"?

You want something like:

Please Login or Register  to view this content.

Yes, exactly. Thanks for this, I'll let you know how it works on Monday.

Please Login or Register  to view this content.

Working like a charm! Thanks