How to add data labels from a series not displayed on a chart
 

I want to add data labels to a chart from a series not displayed on the
chart. e.g. show sales growth % above sales data. ( Excel 2000/2003)

How to add data labels from a series not displayed on a chart
 

Hi,

You can 'hide' a dataseries by on the 'Patterns' tab of format data series
selecting Border - None and Area - None. The data labels will still be
visible.

Regards,

Chris.


--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"doctor bm" wrote:

I want to add data labels to a chart from a series not displayed on the
chart. e.g. show sales growth % above sales data. ( Excel 2000/2003)

How to add data labels from a series not displayed on a chart
 

If you want to apply labels which are not associated with the series being
plotted, but are labels from the worksheet, you can use a utility like one
of the following to apply the labels:

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

Both are free Excel add-ins, easy to install and use.

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

"Chris Marlow" wrote in message
...
Hi,

You can 'hide' a dataseries by on the 'Patterns' tab of format data series
selecting Border - None and Area - None. The data labels will still be
visible.

Regards,

Chris.


--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"doctor bm" wrote:

I want to add data labels to a chart from a series not displayed on the
chart. e.g. show sales growth % above sales data. ( Excel 2000/2003)