What I want to do seems so basic and easy, yet Excel doesn't seem to have
standard functionality to accomplish it. All I want to do is put names on
data points in a scatter plot chart. The only options XL seems to have is to
put the x-axis value, the y-axis value, and/or the series name on the
individual data points. What I would like to do is to have a third data
series in the data set that gives a name to the data point. What I am trying
to do is like a Gartner-group "magic quadrant" chart. Each data point has an
x-value and a y-value that indicate its position, and then on the actual
chart, there is the individual name of each data point next to its dot. As a
consultant, I put these types of charts together almost daily, and right now,
the only way I seem to be able to do it is to build it graphically in
PowerPoint. Help Please!!

You can use Rob Bovey's XY Chart Labeler to add labels. It's a free
add-in that you can download from his web site:

http://www.appspro.com/Utilities/ChartLabeler.htm


Bradfro wrote:
What I want to do seems so basic and easy, yet Excel doesn't seem to have
standard functionality to accomplish it. All I want to do is put names on
data points in a scatter plot chart. The only options XL seems to have is to
put the x-axis value, the y-axis value, and/or the series name on the
individual data points. What I would like to do is to have a third data
series in the data set that gives a name to the data point. What I am trying
to do is like a Gartner-group "magic quadrant" chart. Each data point has an
x-value and a y-value that indicate its position, and then on the actual
chart, there is the individual name of each data point next to its dot. As a
consultant, I put these types of charts together almost daily, and right now,
the only way I seem to be able to do it is to build it graphically in
PowerPoint. Help Please!!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks Debra!! That is perfect. Wow, so many long nights in PowerPoint have
all flashed before my eyes. Thanks again!!


"Debra Dalgleish" wrote:

You can use Rob Bovey's XY Chart Labeler to add labels. It's a free
add-in that you can download from his web site:

http://www.appspro.com/Utilities/ChartLabeler.htm


Bradfro wrote:
What I want to do seems so basic and easy, yet Excel doesn't seem to have
standard functionality to accomplish it. All I want to do is put names on
data points in a scatter plot chart. The only options XL seems to have is to
put the x-axis value, the y-axis value, and/or the series name on the
individual data points. What I would like to do is to have a third data
series in the data set that gives a name to the data point. What I am trying
to do is like a Gartner-group "magic quadrant" chart. Each data point has an
x-value and a y-value that indicate its position, and then on the actual
chart, there is the individual name of each data point next to its dot. As a
consultant, I put these types of charts together almost daily, and right now,
the only way I seem to be able to do it is to build it graphically in
PowerPoint. Help Please!!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome! I'm glad you'll be spared from further torture. <g

Bradfro wrote:
Thanks Debra!! That is perfect. Wow, so many long nights in PowerPoint have
all flashed before my eyes. Thanks again!!


"Debra Dalgleish" wrote:


You can use Rob Bovey's XY Chart Labeler to add labels. It's a free
add-in that you can download from his web site:

http://www.appspro.com/Utilities/ChartLabeler.htm


Bradfro wrote:

What I want to do seems so basic and easy, yet Excel doesn't seem to have
standard functionality to accomplish it. All I want to do is put names on
data points in a scatter plot chart. The only options XL seems to have is to
put the x-axis value, the y-axis value, and/or the series name on the
individual data points. What I would like to do is to have a third data
series in the data set that gives a name to the data point. What I am trying
to do is like a Gartner-group "magic quadrant" chart. Each data point has an
x-value and a y-value that indicate its position, and then on the actual
chart, there is the individual name of each data point next to its dot. As a
consultant, I put these types of charts together almost daily, and right now,
the only way I seem to be able to do it is to build it graphically in
PowerPoint. Help Please!!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html