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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.
 
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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inside Base Series Label Showing #N/A 0
Stack Chart Help 1
Macro to change position of chart labels on line chart 1
Data Series Label Positioning 5
insert data labels from range not used in chart 1
Display Name of each Data Series 1
Excel 07 - Stacked Chart Labels on Negative Values 1
Not plot a data series in a chart but still display in data table 1

Back
Top