4

I have a table of information in excel in which I have a column for some attribute and two columns of for example X and Y information. I want to plot them in scatter form but with specified color for each attribute. I want to know how to do this in excel. My table is something like the following:

enter image description here

I want to have for all points with label "A", color A, for all points with label "B", color B and for label "C", color C for example.

How can I do this automatically? My data set and number of labels are so much!

user3482383
  • 141

2 Answers2

2

First, create a scatter plot on just one of the attributes (A, for example).

Then, copy the X and Y data (not the labels) for the next attribute, select the chart object, then use Home>Paste>Paste Special from the ribbon to paste the copied data as a new series.

enter image description here

Be sure to select the chart before using Paste Special.

Repeat this process until you have a chart with as many series as attributes. Then edit the series name to whatever you choose.

FlexYourData
  • 7,631
2

Apart Paste Special, we could also use Select Date Source.

Go to Insert > Choose one Scatter Graphic in Charts group, then we will get a blank chart.

Right click this blank chart > Select Date Source > click Add > Enter the Series Name, such as Label A, select the data range for X values and Y values.

enter image description here

Do the same step but select different date ranges for other Label B and Label C.

enter image description here

Emily
  • 4,035