T
Tom
Have several charts that get the data from a master data
sheet which gets its data from several other sheets, thus
a linked formula is involved. X axis is for Jan - Dec. I
only thus far have data for Jan - May. The lines on the
charts are fine for Jan - May, but since there is no data
in June - Dec, the line drops to zero. It make the
production chart look like the person suddenly stopped
working. I realize I can erase the formulas but this is
not acceptable in that several people, not excel
proficient, will be updating their own charts and printing
them. I want the line to stop if the formula totals '0'.
sheet which gets its data from several other sheets, thus
a linked formula is involved. X axis is for Jan - Dec. I
only thus far have data for Jan - May. The lines on the
charts are fine for Jan - May, but since there is no data
in June - Dec, the line drops to zero. It make the
production chart look like the person suddenly stopped
working. I realize I can erase the formulas but this is
not acceptable in that several people, not excel
proficient, will be updating their own charts and printing
them. I want the line to stop if the formula totals '0'.