Adding multiple new series to a Scatter chart

[mjherington]

Hi All,
I am attempting to create a macro to add multiple series to a scatter chart. I have a range for both the X and Y Values (see attached).
At present, I have been manually adding series one by one to the chart, but I have roughly a hundred series to add so this could get tiresome.
I am fairly new to coding/VBA so your help would be much appreciated.

Cheers,
Matt

TEST.xlsx

[Andy Pope]

try this,

Please Login or Register  to view this content.

[watersev]

hi Matt, welcome to Excelforum, option, press Run button or run code "test" - ALT+F8, select "test", press Run button

[mjherington]

This is great Andy, thanks heaps.
Just to follow exactly what you have done here, you have set Xdata and Ydata as a Range, and somewhere told it to grab 3 columns of data for each.
For example, if I wished to add another column for both X and Y for an additional data plot for each series, how would I modify the code?
Thanks again for your help, and sorry if these are all basic 'newbie' type questions.
Best,
Matt

[Andy Pope]

You would need to update the 3's in these two lines, which denotes how many columns to use.

Please Login or Register  to view this content.

[mjherington]

Thanks Andy,
Have I done something wrong here? It does not seem to want to plot when I change the code to denote one column as you suggest above.
I have also added a title and axis labels to the code, which seems to be working ok.
Thanks again for your help.
Cheers,
Matt

Please Login or Register  to view this content.

[Andy Pope]

How would you envisage the line to appear if you only give it 1 data value.

to see a line you need a minimum of start xy and finish xy

[mjherington]

Ah, now I feel foolish. Changing chart type would be useful ;-)
Thanks very much Andy for your help.
Regards,
Matt

[mjherington]

Hi Andy,
Sorry to bother you again. I have been trawling the internet for a VBA solution to format the markers as defined (in the example, determined by column D).
I have not yet been able to implement any of them successfully.
Can you help at all?

Thank you kindly.
Best,
Matt