Excel Scatter Plot With Multiple Series From 1 Table. Click the Add button and the Edit Series dialog appears. 2 Add the error bars for the column chart series.
Select B1B8 hold Ctrl while selecting D1F8 so both areas are selected and insert a scatter plot. Apr 22 2019 How to create a scatter plot in Excel. I am facing some difficulties with plotting grouped data by index in one graph scatter plot with lines in Excel and I will appreciate a lot your help.
Repeat this process for each series pair.
Charts group and choose the chart type you want to make. Next click Insert tab. And Categories in Fist column. What I want to do is create a series I think this is the right word for it for the different locations.
