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

N

neowok

this could be a bit of a problem as the data comes from some very larg
sheets which contain the data for several months worth of days
including the next couple of months, so adding a helper column would b
difficult. The graphs are all automated so they base themselves on th
next day along without any intervention so manuallt creating thi
helper column each day would also not be possible.

Is there some other way to do it?

thank
 
A

Andy Pope

Hi,

Maybe you could use a custom number format.

General;General;"None Planned"

All data labels with zero will actual display "None Planned"

If not some VBA code would be needed.

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

Top