I'd like to plot both data sets of absorption (y) on one time axis (x) but i can't find a way to include the two different sets of x. Sub creatingchartonchartsheet() dim ch as chart dim xrng as range dim yrng1 as range dim yrng2 as range set ch = charts.add set xrng = sheets(power).range(a2:a65536) set yrng1 = sheets(power).range(d2:d65536) set yrng2 = sheets(power).range(e2:e65536) with ch ' if there is a previous chart, delete it for each chart in activeworkbook.charts if. After the separation of the x and y coordinates, we will be making a scatter plot for the data in the next step.Ĭlick scatter with straight lines. Both of the scatter axes contain numeric values.ĭo not select any other columns to avoid confusing excel. Because excel does a great job at providing scatter plot options that use color, you can add another data set to your chart. Now in the dataset, we have two columns one for x data points and the other for y data points. How to make a scatter plot in excel with multiple data sets. Select the chart type you want for each data series from the dropdown options.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |