getting data labels on xy chart from additional plot area

[Adri S.]

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!

 

[Jon Peltier]

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

 

[Adri S.]

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

 

[Shane Devenshire]

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.]

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

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