Line Graph Problem

#1 10-05-2005, 06:05 PM

Hello - I am having a problem with a line graph I have. Basically the line
graph is populated on a month to month basis, from protected cells that
contain formulas.

This is an example of the formula for each month: =IF(J35 =
"","",AVERAGE(J35,J49,J63))

My problem is if I'm in august, (thus september shows up as ""), the line
(say it was at 98% in August), drops off to zero which makes an ugly graph.
If I delete the formulas entirely from Sept-Dec, then it looks fine, but that
defeats the purposes of the protected cells.

Anyone know of a formula i can throw into "September" that wont make the
graph look lke it goes to zero that month? Thanks!

#2 10-05-2005, 09:05 PM

Change the formula to

=IF(J35 = "",NA(),AVERAGE(J35,J49,J63))

"Nick I" <NickI@discussions.microsoft.com> wrote in message
news:245C82DA-F486-42EA-BC24-3C278BDD7F61@microsoft.com...
> Hello - I am having a problem with a line graph I have. Basically the line
> graph is populated on a month to month basis, from protected cells that
> contain formulas.
>
> This is an example of the formula for each month: =IF(J35 =
> "","",AVERAGE(J35,J49,J63))
>
> My problem is if I'm in august, (thus september shows up as ""), the line
> (say it was at 98% in August), drops off to zero which makes an ugly
> graph.
> If I delete the formulas entirely from Sept-Dec, then it looks fine, but
> that
> defeats the purposes of the protected cells.
>
> Anyone know of a formula i can throw into "September" that wont make the
> graph look lke it goes to zero that month? Thanks!

#3 10-06-2005, 11:05 AM

Thanks! That fixed the problem.

"Barb Reinhardt" wrote:

> Change the formula to
>
> =IF(J35 = "",NA(),AVERAGE(J35,J49,J63))
>
> "Nick I" <NickI@discussions.microsoft.com> wrote in message
> news:245C82DA-F486-42EA-BC24-3C278BDD7F61@microsoft.com...
> > Hello - I am having a problem with a line graph I have. Basically the line
> > graph is populated on a month to month basis, from protected cells that
> > contain formulas.
> >
> > This is an example of the formula for each month: =IF(J35 =
> > "","",AVERAGE(J35,J49,J63))
> >
> > My problem is if I'm in august, (thus september shows up as ""), the line
> > (say it was at 98% in August), drops off to zero which makes an ugly
> > graph.
> > If I delete the formulas entirely from Sept-Dec, then it looks fine, but
> > that
> > defeats the purposes of the protected cells.
> >
> > Anyone know of a formula i can throw into "September" that wont make the
> > graph look lke it goes to zero that month? Thanks!
>
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)