website page counter

Excel Scatter Plot With Multiple Series From 1 Table

Best image references website

Excel Scatter Plot With Multiple Series From 1 Table. And Categories in Fist column. Apr 22 2019 How to create a scatter plot in Excel.

How Do I Create A Chart With Multiple Series Using Different X Values For Each Series Stack Overflow
How Do I Create A Chart With Multiple Series Using Different X Values For Each Series Stack Overflow from stackoverflow.com

Also see the subtype Scatter with Smooth Lines. In D2 enter this formula. Set the options as in the screen shot ie.

Under Chart group you will find Scatter X Y Chart.

Select two columns with numeric data including the column headers. Excel makes some awful mess of this - misplotting data against some summed x-axis. Type a comma and select the second range of X values. On the Insert tab in the Charts group click the Scatter symbol.

close