Excel Vba Scatter Plot Multiple Series. In Excel Online there is no option to add series. I have the following list of values which I want to plot as a zigzag.
If A1 has a number ISNUMBER function should work fine here I believe then plot series. In Excel Online there is no option to add series. Aug 01 2005 Series 1 Data Data Series 2 Data Data Series 3 Data Data etc.
For many many rows Id like to select the whole set of data and plot an xy chart identifying that the data is in rows and the first column contains the series name.
How can i plot multiple series of values in one graph after checking some check boxes which i have previously done randomly. What you are after is a dynamic chart for which you can change the range of plotted values. Sign under Legend entries Series in the below screenshot to add series. If A1 has a number ISNUMBER function should work fine here I believe then plot series.
