Excel Vba Create Scatter Plot Multiple Series. Dec 07 2019 Select all the cells that contain data. Two Y-axes Left and Right of ChartsPrimary Axis and Secondary Axis using Excel VBA.
However you can add data by clicking the Add button above the list of series which includes just the first series. The data source for the new series is range B1B10 on Sheet1. This method does not actually return a Series object as stated in the Object Browser.
This method is not available for PivotChart reports.
Click the arrow to see the different types of scattering and bubble charts. Creating a Scatter Plot using VBA and i have multiple XY series that i want to use. The data source for the new series is range B1B10 on Sheet1. This example creates a new series on Chart1.
