View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Chris Marlow
 
Posts: n/a
Default 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)