changing a series 'value' label to 'none planned' ?

  • Thread starter Thread starter neowok
  • Start date Start date
N

neowok

I have 2 graphs which show planned and actual manpower figures for
various work sites for a day. Sometimes there are no planned workers
on site for that day and I would like to display 'None Planned' rather
than the usual '0' which appears if there are none planned.

Is this possible?
 
Hi,

You will need to add a helper column that contains the information you
want to display in a data label. You can then link the data labels to cells.
To make the process of linking data labels to cells try either of these
free addin.

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

Cheers
Andy
 
Back
Top