Scatter chart creation with labels

[JulieB]

I would like to create a scatter chart where the labels show up instead of the dots. I have a matrix where the labels are in column 1, then the x coordinates in column 2, and the Y coordinates in column 3. The coordinates are all integers.
I would make the grid large enough to accommodate the labels, and would like the option to left justify or center them.
Thank you for your help.


Post Moved by Mod to Appropriate Forum Section.


.

 

[Hui]

JulieB

Firstly, Welcome to the Chandoo.org Forums

Setup a Scatter chart as normal
then add the labels
Then set the fill of the Chart Line and Markers to None
If the labels are too big, change the X Axis Min/Max by a little bit +/- 0.5

If you have some real data posting a sample file allows us to give you a more targetted response

 

[Hui]

see attached file:

 

[JulieB]

JulieB

Firstly, Welcome to the Chandoo.org Forums

Setup a Scatter chart as normal
then add the labels
Then set the fill of the Chart Line and Markers to None
If the labels are too big, change the X Axis Min/Max by a little bit +/- 0.5

If you have some real data posting a sample file allows us to give you a more targetted response

 

[Hui]

Julie,

Did you mean to say something or attach anything ?

 

[JulieB]

Hui, I downloaded the attached file, but where you show "Label 1", "Label2", etc. , I get [CELLRANG E]. I don't know how to select the data labels that I want.
Thank you again for your help.

 

[Hui]

You are using a version of Excel that doesn't support cell ranges for data labels

If you read : http://chandoo.org/wp/2010/05/05/change-data-labels-in-charts/
It describes technqiues fro adding labels connected to a range