Point labels in an Excel scatter plot to be associated text
 

I am trying to plot a scatter plot where I would like each point to have a
specific name. For instance, I have three columns, company name, total
revenue, and % margin. I would like to plot revenu vs. % margin and when
clicking on a specific point, I would like to find out the company name.

Answer: Point labels in an Excel scatter plot to be associated text
 

Sure, I can help you with that! Here are the steps to add labels to your scatter plot in Excel:

1. First, select the data you want to plot, including the company name, total revenue, and % margin columns.
2. Click on the "Insert" tab in the ribbon at the top of the Excel window.
3. Click on the "Scatter" chart type in the "Charts" section of the ribbon.
4. Excel will create a basic scatter plot for you. Now, right-click on any of the data points in the chart and select "Add Data Labels" from the context menu.
5. The data labels will appear on the chart, but they will be the values of the data points (i.e. revenue and % margin). To change the labels to the company names, right-click on any of the data labels and select "Format Data Labels" from the context menu.
6. In the "Format Data Labels" pane that appears on the right side of the Excel window, select the "Values From Cells" option under the "Label Options" section.
7. Click on the "Select Range" button and then select the column that contains the company names.
8. Click "OK" to close the "Format Data Labels" pane.
9. Now, when you hover over a data point in the scatter plot, you should see the company name as the label.

That's it! You should now have a scatter plot with labels that show the company names when you hover over the data points.

Check out Rob Bovey's Chartlabeler at www.appspro.com or John
Walkenbach's Chart Tools at www.j-walk.com.

If you want to see the labels only when you hover the mouse over a
point see
Hover Chart Label
http://www.tushar-mehta.com/excel/so...bel/index.html
Note that the add-in includes a chart labeler capability.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , =?Utf-
8?B?UG9pbnQgbGFiZWxzIGluIHNjYXR0ZXIgcGxvdCAtIHRleH Q/?= <Point labels in
scatter plot - says...
I am trying to plot a scatter plot where I would like each point to have a
specific name. For instance, I have three columns, company name, total
revenue, and % margin. I would like to plot revenu vs. % margin and when
clicking on a specific point, I would like to find out the company name.

Point labels in scatter plot - text? Wrote:
I am trying to plot a scatter plot where I would like each point to have
a
specific name. For instance, I have three columns, company name,
total
revenue, and % margin. I would like to plot revenu vs. % margin and
when
clicking on a specific point, I would like to find out the company
name.

Hi, There is very elegant way of doing this in Excel without any third
party add-ins. I explain you how to do this in following steps:
Step1: Organize your data as follows
A B C
1 Company Revenue (X) Margin (Y)
2 C1 200 12
3 C2 100 20

Step2: Plot a XY Scatter plot using MS Excel®, by selecting only B1:C3.
Select series in: Column (don’t select Series in: Rows). This would
produce your desired Revenue vs. %Margin Plot with Revenue on the XAxis
& %Margin on YAxis. Have your leveling of axes done.

Step3: Click on the data point on the XY scatter it would select the
data series. Then click once again on the individual data point to
select it alone say for instance, point (Revenue=200, %Margin=12).
Right click on the selected data point --Select Format Data
Series--Select Data Label--Show Value

Step4: This would show the value of %Margin (= 20 in this case) beside
the selected data point (Revenue=200, %Margin=12). Now double click on
the label you have just created, this would give you a text box
surrounding your label. Write company name in this text box (C1 in this
case). Do the same for other data points as well. Now you have the third
data value referenced to your data points. This is dynamic, even if you
change the source data value (say the Revenue/Margin), company name
would move along with the data point.

Alternatively, you have to buy/download some Excel Ad-ins that lets you
show data label. One such free download is available at:
http://www.xl-logic.com/pages/addins.html download the
xy-levels.zip.
Hope this helps you :-)
Regards,
Kartik Thakur
Email:


--
k_thakur
------------------------------------------------------------------------
k_thakur's Profile: http://www.excelforum.com/member.php...o&userid=26281
View this thread: http://www.excelforum.com/showthread...hreadid=390270

You neglected to explain how to make the label dynamic in terms of
pointing to the cell, so that the data label in the chart changes when
the label in the cell changes. Select the series of labels, then select
the specific label (two single clicks), then without clicking to put the
cursor into the pseudo-text box, type the equals key, then click on the
cell with the mouse.

Both of the following free add-ins link the the cell in this way. Rob's
has the added feature that it copies the cell's text formatting to the
data label, although the formatting remains what it was when the label
was created, and doesn't change if you change the formatting in the
worksheet.

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com/ss

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

The manual technique is nice to know, but becomes tedious after about
the third label.

k_thakur wrote:

Point labels in scatter plot - text? Wrote:

I am trying to plot a scatter plot where I would like each point to have
a
specific name. For instance, I have three columns, company name,
total
revenue, and % margin. I would like to plot revenu vs. % margin and
when
clicking on a specific point, I would like to find out the company
name.


Hi, There is very elegant way of doing this in Excel without any third
party add-ins. I explain you how to do this in following steps:
Step1: Organize your data as follows
A B C
1 Company Revenue (X) Margin (Y)
2 C1 200 12
3 C2 100 20

Step2: Plot a XY Scatter plot using MS Excel®, by selecting only B1:C3.
Select series in: Column (don’t select Series in: Rows). This would
produce your desired Revenue vs. %Margin Plot with Revenue on the XAxis
& %Margin on YAxis. Have your leveling of axes done.

Step3: Click on the data point on the XY scatter it would select the
data series. Then click once again on the individual data point to
select it alone say for instance, point (Revenue=200, %Margin=12).
Right click on the selected data point --Select Format Data
Series--Select Data Label--Show Value

Step4: This would show the value of %Margin (= 20 in this case) beside
the selected data point (Revenue=200, %Margin=12). Now double click on
the label you have just created, this would give you a text box
surrounding your label. Write company name in this text box (C1 in this
case). Do the same for other data points as well. Now you have the third
data value referenced to your data points. This is dynamic, even if you
change the source data value (say the Revenue/Margin), company name
would move along with the data point.

Alternatively, you have to buy/download some Excel Ad-ins that lets you
show data label. One such free download is available at:
http://www.xl-logic.com/pages/addins.html download the
xy-levels.zip.
Hope this helps you :-)
Regards,
Kartik Thakur
Email: