Add Custom Labels to x-y Scatter plot in Excel

In this tutorial we will learn how to add a custom label to scatter plot in excel.Below we have explained how to add custom labels to x-y scatter plot in Excel.

Data used:  Sale of Different flavors of ice cream on Store 1 and Store 2.

Flavor Store 1 Store 2
Vennila 45 80
Chocolate 60 35
Strawberry 65 45
Caramel 34 36
kulfi 10 62
Bacon 45 34

Step 1: Select the Data, INSERT -> Recommended Charts -> Scatter chart (3rd chart will be scatter chart)

Let the plotted scatter chart be

Scatter plot with label 1

 

Step 2:  Click the + symbol and add data labels by clicking it as shown below

Scatter plot with label 2

Step 3: Now we need to add the flavor names to the label. Now right click on the label and click format data labels. Under LABEL OPTIONS select Value From Cells as shown below.

Scatter plot with label 3

Step 4: A POP up will open and select the data label range, in our case from A2: A7 and click ok as shown below

Scatter plot with label 4

Step 5: Now the ice cream flavors will appear on the labels. Click on X Value and Y Value under LABEL OPTIONS. So the resultant chart will give you scatter plot with Labels of flavors and Label of X values and Y values (x, y coordinates) as shown below

Scatter plot with label 5

Step 6: Add the suitable title and axis labels so the final chart will be

Scatter plot with label 6

Example: Sale of vennila flavor on store 1 is 45 units and store 2 is 80 units.

 

Add Custom Labels to x-y Scatter plot in Excel                                                                                                                Add Custom Labels to x-y Scatter plot in Excel - image next_small-11-1 on http://www.datasciencemadesimple.com