Excel Vba Create Scatter Plot Multiple Series. The following VBA program first creates the data function createTestData and then iterates over each row of the test data to format the data points in the resulting scatter plot. Excel Chart and Charting Tips and Tricks Also search the forum on the topic of Dynamic Charts.
This I did manually through the format data series dialog. Im using seriescollect and the program works with just one set of data and i try to use more than on and i. Microsoft Excel - Scatter Plot with Multiple Series either Vba Code or help how to Asked By Paul on 19-Feb-14 1131 AM hi i am trying to create a scatter plot with multiple series on them i have probalby over 200 Customer in a list which changes when you you select a product so some can NA Vlaues in the range.
The data source for the new series is range B1B10 on Sheet1.
Dec 07 2019 Select all the cells that contain data. A If a SeriesCollectionCount Then With SeriesCollectionaXValues SheetsstrNameRangeE3E. Right click the chart and choose Select Data or click on Select Data in the ribbon to bring up the Select Data Source dialog. Aug 18 2006 Re.
