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

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?
 
A

Andy Pope

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
 

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

changing a series 'value' label to 'none planned' ? 2
showing a target value on a stacked bar 0
stacked column- value axis not displaying correct values 0
Chart SERIES OFFSET 5
Negative Float & Planned finish time 1
Sample Size as Series Data Label 1
Editing a column chart for Variance Walk negative numbers 3
Labeling on independently stacked line chart 0

Top