Data point labels in a scatter diagram

S

sdstephens

My Y axis is from my "Units" column and my X axis is from my "Revenue"
column. How do I get a third column like "Company Name" to appear as the
labels for the data points in my scatter diagram?
 
L

Larissa

Right click your plot area, choose Source Data, on Series tab in the box with
series names highlight the series you want, to the right of it there is an
option to choose your cell containing the name, repeat this for both of your
series, then right click on the series in your chart, choose Format Series,
on Data Labels tab check Series Name check box.

Good Luck,
Larissa
 
S

sdstephens

Thanks, Larissa, but I don't see the Series Name check box. Is that an
option in Excel 2000? I should have mentioned what version I'm using.

-Scott
 
L

Larissa

I am using 2003
But, you can still just right click your series, ask to show either one
value or category name, they will appear in text boxes next to your points on
the chart, you can actually edit contents in the text boxes any way you want.
Try this see if it works in 2000

Larissa
 
S

sdstephens

Still doesn't work. I can choose to show either the value or the label,
which shows either my X or Y axis. I don't think Excel 2000 can do it
without an add-in or macro.

Thanks,
Scott
 
S

sdstephens

I can't see where Larissa actually mentions an add-in. I did find a post
from back on December with a macro that worked well. Do you know the name of
the add-in that does this?

Thanks, Jon.
 
S

sdstephens

Thanks, Kelly. Unforatunately, this is a work computer and locked down so
that we can't install any software.

-Scott
 
S

sdstephens

It's probably possible, especially since I used to work on the IT team that
controls our systems but since I found that macro, it's probably not worth my
time to ask for new software.

Thank you to everyone that took the time to help out. You guys are great!

-Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparative Scatterplot?? 1
How do I adjust marker spacing in Excel scatter plot? 1
problem with scatter diagram excel 2007 2
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Scatter plots in excel 2007 1
Customised Axis Values 2
Data Labels xy scatter plot 1
adding data labels to an XY scatterplot 1

Top