Programmable charts

[marioforum]

Hi all!

I am new here, and I hope someone can (and will) help me.

I would like to make macro which will draw chart, but user will specify which rows to use in chart. Because there will be a lot of data and is useful to choose only 3 to 5 series to plot.
The x value is common for all plots.

I attached some example, just that you can understand what I want.

Thank you in advance!

[Andy Pope]

Here is one way using Autofilter.
The listbox is a multi select style listbox.

[marioforum]

That is good idea for that type of table. Thks!

Actually, I also wondering is it possible to use variables in code for adding series to the chart:

ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R10C4:R10C10"
ActiveChart.SeriesCollection(1).Values = "=Sheet1!R11C4:R11C10"
ActiveChart.SeriesCollection(1).Name = "=""Hc1"""

I tried something like that (..."=Sheet1!Rvarible1Cvariable2:Rvariable3Cvariable4" ) but it didn't work. Maybe something else.?
The main thing is that I want to use variables to add series to chart, beacuse I will have changeable number of rows and columns in the table.

I hope that you can understand me.

[Andy Pope]

If you turn the data table in to a List then it will automatically expand for new rows of data.

Here is the code to add new series.

Please Login or Register  to view this content.