| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 conversion - this file contains labels in formulas | Excel Discussion (Misc queries) | |||
| Excel 2007 labels in functions no longer supported! | Excel Worksheet Functions | |||
| label invidual points in an XY scattergraph | Excel Discussion (Misc queries) | |||
| In excel display multiple same value points on a scattergraph | Excel Discussion (Misc queries) | |||
| How do I have unique data labels for points in a XY Scatter plot? | Charts and Charting in Excel | |||
Hybrid Mode
