Excel 2007 - Adding Labels to Scattergraph Points
 

I've got three pieces of data for each person on the payroll - each in a
column

- salary
- length of service
- Dept Abbrev (3 alpha characters)

I've created the scattergraph on salary/length of service (which I want) -
but is there a way I can display the person's Dept as the label against each
point

Tx

Rob

Excel 2007 - Adding Labels to Scattergraph Points
 

Hi,

Still no built in way to use a separate column for data label text.

There is a free addin you can use.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"RFJ" wrote in message
...
I've got three pieces of data for each person on the payroll - each in a
column

- salary
- length of service
- Dept Abbrev (3 alpha characters)

I've created the scattergraph on salary/length of service (which I want) -
but is there a way I can display the person's Dept as the label against
each point

Tx

Rob

Excel 2007 - Adding Labels to Scattergraph Points
 

Tx - solved the problem at no cost <BG

Cheers

Rob

"Andy Pope" wrote in message
...
Hi,

Still no built in way to use a separate column for data label text.

There is a free addin you can use.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"RFJ" wrote in message
...
I've got three pieces of data for each person on the payroll - each in a
column

- salary
- length of service
- Dept Abbrev (3 alpha characters)

I've created the scattergraph on salary/length of service (which I
want) - but is there a way I can display the person's Dept as the label
against each point

Tx

Rob