I am creating a scatter chart that is designed to show trends in employee
performance. Employees are rated with 2 different tools, each using a 5 point
scale. I am able to plot the intersection of each tool rating without a
problem. However, I would like to be able to add a data label that is
employee name. When I add names to the data series, my xy chart now plots
each tool as a separate data point, not as an intersection.

So...when I use source data like below, the chart looks fine, but employee
name is not included.

Tool 1 Tool2
-------------------
4 5
3 4
5 5

So Tool 1 is the x axis and Tool2 is the y axis, and the chart plots one
data point for each row.

When my data source appears as below, the chart now plots one data point for
each rating, instead of the intersection of Tool1 and Tool2.

Tool 1 Tool2
-------------------
Bill Smith 4 5
Sue Jones 3 4
Mary Allen 5 5

So, I need help plotting Tool 1 and Tool2 on an xy chart, and be able to
have the employee name appear as a data label. Thank you in advance!

Check out these useful (and free) utilities:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Adri S." wrote in message
...
I am creating a scatter chart that is designed to show trends in employee
performance. Employees are rated with 2 different tools, each using a 5
point
scale. I am able to plot the intersection of each tool rating without a
problem. However, I would like to be able to add a data label that is
employee name. When I add names to the data series, my xy chart now plots
each tool as a separate data point, not as an intersection.

So...when I use source data like below, the chart looks fine, but employee
name is not included.

Tool 1 Tool2
-------------------
4 5
3 4
5 5

So Tool 1 is the x axis and Tool2 is the y axis, and the chart plots one
data point for each row.

When my data source appears as below, the chart now plots one data point
for
each rating, instead of the intersection of Tool1 and Tool2.

Tool 1 Tool2
-------------------
Bill Smith 4 5
Sue Jones 3 4
Mary Allen 5 5

So, I need help plotting Tool 1 and Tool2 on an xy chart, and be able to
have the employee name appear as a data label. Thank you in advance!

WOW! The Chart Labeler was exactly what I needed. Thank you so much for
providing these links. Problem solved.

"Jon Peltier" wrote:

Check out these useful (and free) utilities:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Adri S." wrote in message
...
I am creating a scatter chart that is designed to show trends in employee
performance. Employees are rated with 2 different tools, each using a 5
point
scale. I am able to plot the intersection of each tool rating without a
problem. However, I would like to be able to add a data label that is
employee name. When I add names to the data series, my xy chart now plots
each tool as a separate data point, not as an intersection.

So...when I use source data like below, the chart looks fine, but employee
name is not included.

Tool 1 Tool2
-------------------
4 5
3 4
5 5

So Tool 1 is the x axis and Tool2 is the y axis, and the chart plots one
data point for each row.

When my data source appears as below, the chart now plots one data point
for
each rating, instead of the intersection of Tool1 and Tool2.

Tool 1 Tool2
-------------------
Bill Smith 4 5
Sue Jones 3 4
Mary Allen 5 5

So, I need help plotting Tool 1 and Tool2 on an xy chart, and be able to
have the employee name appear as a data label. Thank you in advance!

Hi Adri,

(tongue in cheek) - just use Lotus 1-2-3 version 1. Yes you could do this
in the very first version of lotus without any add-ins or tricks, that was
back in 1982, before I was born. We still don't have it in Excel 2007, 25
years later?

Cheers,
Shane

"Adri S." wrote in message
...
WOW! The Chart Labeler was exactly what I needed. Thank you so much for
providing these links. Problem solved.

"Jon Peltier" wrote:

Check out these useful (and free) utilities:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Adri S." wrote in message
...
I am creating a scatter chart that is designed to show trends in
employee
performance. Employees are rated with 2 different tools, each using a 5
point
scale. I am able to plot the intersection of each tool rating without a
problem. However, I would like to be able to add a data label that is
employee name. When I add names to the data series, my xy chart now
plots
each tool as a separate data point, not as an intersection.

So...when I use source data like below, the chart looks fine, but
employee
name is not included.

Tool 1 Tool2
-------------------
4 5
3 4
5 5

So Tool 1 is the x axis and Tool2 is the y axis, and the chart plots
one
data point for each row.

When my data source appears as below, the chart now plots one data
point
for
each rating, instead of the intersection of Tool1 and Tool2.

Tool 1 Tool2
-------------------
Bill Smith 4 5
Sue Jones 3 4
Mary Allen 5 5

So, I need help plotting Tool 1 and Tool2 on an xy chart, and be able
to
have the employee name appear as a data label. Thank you in advance!

Good ol' Lotus! I remember those days...

"Shane Devenshire" wrote:

Hi Adri,

(tongue in cheek) - just use Lotus 1-2-3 version 1. Yes you could do this
in the very first version of lotus without any add-ins or tricks, that was
back in 1982, before I was born. We still don't have it in Excel 2007, 25
years later?

Cheers,
Shane

"Adri S." wrote in message
...
WOW! The Chart Labeler was exactly what I needed. Thank you so much for
providing these links. Problem solved.

"Jon Peltier" wrote:

Check out these useful (and free) utilities:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Adri S." wrote in message
...
I am creating a scatter chart that is designed to show trends in
employee
performance. Employees are rated with 2 different tools, each using a 5
point
scale. I am able to plot the intersection of each tool rating without a
problem. However, I would like to be able to add a data label that is
employee name. When I add names to the data series, my xy chart now
plots
each tool as a separate data point, not as an intersection.

So...when I use source data like below, the chart looks fine, but
employee
name is not included.

Tool 1 Tool2
-------------------
4 5
3 4
5 5

So Tool 1 is the x axis and Tool2 is the y axis, and the chart plots
one
data point for each row.

When my data source appears as below, the chart now plots one data
point
for
each rating, instead of the intersection of Tool1 and Tool2.

Tool 1 Tool2
-------------------
Bill Smith 4 5
Sue Jones 3 4
Mary Allen 5 5

So, I need help plotting Tool 1 and Tool2 on an xy chart, and be able
to
have the employee name appear as a data label. Thank you in advance!