How can I not graph a 0 value.

[jbd]

I have a graph that is charting monthly sales over an 8 year period. I have my chart set to automatically update as the future data is entered. My problem is that I want my y axis to show all 8 years and my graph line to stop at the current month and not graph the zero values for the future months. Does anyone know how I can do this?

[erin_taylor]

Go to Tools>Options, Click on the Charts tab and choose the "not plotted
option"

"jbd" wrote:

>
> I have a graph that is charting monthly sales over an 8 year period. I
> have my chart set to automatically update as the future data is
> entered. My problem is that I want my y axis to show all 8 years and
> my graph line to stop at the current month and not graph the zero
> values for the future months. Does anyone know how I can do this?
>
>
> --
> jbd
> ------------------------------------------------------------------------
> jbd's Profile: http://www.excelforum.com/member.php...o&userid=35417
> View this thread: http://www.excelforum.com/showthread...hreadid=551874
>
>

[jbd]

Thanks. I tried the "do not plot" and it worked great if my cells were empty, however, the cells that my source data covers are formulas and the graph is reading the formulated cells as 0 and charting it. Any suggestions on how I can make my formulas appear to be empty so my graph won't chart it?

[David Biddulph]

"jbd" <[email protected]> wrote in message
news:[email protected]...
>
> Thanks. I tried the "do not plot" and it worked great if my cells were
> empty, however, the cells that my source data covers are formulas and
> the graph is reading the formulated cells as 0 and charting it. Any
> suggestions on how I can make my formulas appear to be empty so my
> graph won't chart it?

Try to get the formula to return NA(), rather than zero or a blank.
--
David Biddulph