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

  • Thread starter Thread starter neowok
  • Start date Start date
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
 
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
 
Back
Top