Scatter Chart with Named Data Labels

charlieowen

New Member
Joined
Mar 27, 2002
Messages
1
I want to make an x-y scatter chart with named labels on each point.

My data table looks like:
Person Speed Quality
Sue: 4, 7
Joe: 3, 9
Sam: 7, 3
Jane: 5, 5

I want a chart with Speed on the X axis, Quality on the Y axis, a mark at each x-y point, and a data label of the name beside the point.

My actual data has 14+ items whith x-y values which will change as I update the data. If I manually label the data points, I have to manually move the labels each time the data changes.

The only solution I have found is to make 14 separate series with one x-y point each. This method is tedious.
This message was edited by charlieowen on 2002-03-28 12:39
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,214,395
Messages
6,119,265
Members
448,881
Latest member
Faxgirl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top