View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Data point labels in a scatter diagram

Reread my post. I said that Kelly mentioned addins.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"sdstephens" wrote in message
...
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.


"Jon Peltier" wrote:

The options Larissa is talking about were introduced in Excel XP (2002).
The add-ins Kelly mentioned work in Excel 97 through 2003 (and they are
as
good as she claims).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"sdstephens" wrote in message
...
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

"Larissa" wrote:

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


"sdstephens" wrote:

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

"Larissa" wrote:

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

"sdstephens" wrote:

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?