Line Graph Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick I - 05 Oct 2005 21:44 GMT

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!

Reply to this Message

Barb Reinhardt - 06 Oct 2005 00:25 GMT

Change the formula to

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

> 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
[quoted text clipped - 12 lines]
> Anyone know of a formula i can throw into "September" that wont make the
> graph look lke it goes to zero that month? Thanks!

Reply to this Message

Nick I - 06 Oct 2005 14:06 GMT

Thanks! That fixed the problem.

> Change the formula to
>
[quoted text clipped - 16 lines]
> > Anyone know of a formula i can throw into "September" that wont make the
> > graph look lke it goes to zero that month? Thanks!

Reply to this Message