How do I ensure that in a chart zero(0) values are not shown ?
I just saw the answer to the same question earlier today and this works, so
solved....
"ccdae" wrote:
I have a series of cells in which a value is calcualted every month and a
Graph which displayes the result. For future months the Graph shows a line
from the last value to '0'. How can I ensure that this is not shown withouth
copying the formula each time at the end of the month ?
|