Hi,
Is it possible to add the test 1 -5 labels to the points on the scatter chart in the attached sample? If not...how can I simulate the chart as it is shown and include the test labels in the A column on the data points?
TX
How to add labels to a scatter chart?
-
Rudi
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
How to add labels to a scatter chart?
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
HansV
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to add labels to a scatter chart?
You could select each data label in turn and enter a formula in the formula bar. For example, if you select the label for the first point (277,280), you could enter =A2 in the formula bar, and so on for the other points.
An easier solution is to use Rob Bovey's free XY Chart Labeler add-in.
An easier solution is to use Rob Bovey's free XY Chart Labeler add-in.
Best wishes,
Hans
Hans
-
stuck
- Panoramic Lounger
- Posts: 8178
- Joined: 25 Jan 2010, 09:09
- Location: retirement
Re: How to add labels to a scatter chart?
Yes, Rob Bovey's chart labeller, the must have XL add-in.
signed,
"avid fan" since ~2000
signed,
"avid fan" since ~2000
-
Rudi
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: How to add labels to a scatter chart?
Tx Hans...I'll try that labeler
Cheers
Cheers
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.