Excel is plotting additional series not asked by the VBA code.

[kyleg222]

Hello Everyone,

I am new to the forum and VBA coding. I have created some code that is to plot a series of data in an XY Scatter plot. However, when I run the code it plots additional series on the plot that I have not asked the code to plot.

A small portion of the code is below, which draws the first chart on the worksheet. The additional number of series is much higher on worksheets Plate w Hole 1 and above. I have attached a copy of the workbook as well. The entire code will not run on most computers because it is communicating with another piece of software. However the graph drawing is in the post processing stage of my analysis and only occurs within Excel.

Please Login or Register  to view this content.

Attachment 166414

[mrice]

You might try selecting an empty isolated cell prior to creating the chart to prevent the automatic inclusion of unwanted series. If this doesn't work, you could try counting the series immediately after the creation of the chart and deleting them.

[kyleg222]

Thank you mrice simply selecting an empty cell prior to creating each chart prevented the inclusion of unwanted series.