ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Scatter Plot and Axes labels (https://www.excelbanter.com/charts-charting-excel/49290-scatter-plot-axes-labels.html)

Baapi

Scatter Plot and Axes labels
 
if I have my data as
Sl. Production Quality
1. 10 10%
2. 20 30%
3. 56 56%
4. 98 12%

and want to know who is in the high Production/High Quality, High
Production/Low Quality etc.. the 4 areas, I can use the xy scatter plot.

but the points which represent these data cannot be labelled. How do I know
which point on the graph corresponds to which person (Sl. No.)?

OR

How do I label data points in an XY Scatter plot?
--
Baapi

Andy Pope

Hi,

Here are a couple of free addin for linking data labels to cells.

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

Cheers
Andy

Baapi wrote:
if I have my data as
Sl. Production Quality
1. 10 10%
2. 20 30%
3. 56 56%
4. 98 12%

and want to know who is in the high Production/High Quality, High
Production/Low Quality etc.. the 4 areas, I can use the xy scatter plot.

but the points which represent these data cannot be labelled. How do I know
which point on the graph corresponds to which person (Sl. No.)?

OR

How do I label data points in an XY Scatter plot?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com