How do I keep my chart line from dropping to zero for the upcoming weeks that
do not have data. I am using a formula to calculate my 52 week progress. The
chart graphs the weeks correctly that have data, but drops to zero for the
upcoming weeks. I am trying to use a line graph.

Thanks,
--
keith jones

For the weeks that you have no data, enter =NA(). This displays as #N/A and
is ignored by the chart engine
Don't like this idea because it looks odd when you print your report? The
hide these entries with conditional format. Suppose the data is in B2:B53,
select this range, use Format | Conditional Formatting and in dialog use
Formula Is ...=ISNA(B2) and set the font to the same colour as the cell's
background to make it invisible

Alternatively: click on chart then use Tools | Options | Charts and specify
how empty cells are to be treated

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"kajones" wrote in message
...
How do I keep my chart line from dropping to zero for the upcoming weeks
that
do not have data. I am using a formula to calculate my 52 week progress.
The
chart graphs the weeks correctly that have data, but drops to zero for the
upcoming weeks. I am trying to use a line graph.

Thanks,
--
keith jones

Thanks,,,that helped with part of it. Now I have another problem. For some
reason my graph points for the first three weeks show as zero. I am using a
Vlookup to pull the data from another file. Is there something else that I
need to do in my chart to make it show up correctly on the chart. If I go
back and type over the formula with just the number that it gives me it works
okay.


--
keith jones


"Bernard Liengme" wrote:

For the weeks that you have no data, enter =NA(). This displays as #N/A and
is ignored by the chart engine
Don't like this idea because it looks odd when you print your report? The
hide these entries with conditional format. Suppose the data is in B2:B53,
select this range, use Format | Conditional Formatting and in dialog use
Formula Is ...=ISNA(B2) and set the font to the same colour as the cell's
background to make it invisible

Alternatively: click on chart then use Tools | Options | Charts and specify
how empty cells are to be treated

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"kajones" wrote in message
...
How do I keep my chart line from dropping to zero for the upcoming weeks
that
do not have data. I am using a formula to calculate my 52 week progress.
The
chart graphs the weeks correctly that have data, but drops to zero for the
upcoming weeks. I am trying to use a line graph.

Thanks,
--
keith jones

Would need to see the file. Just make up some data that mimics your actual
data and chart (to preserve confidentiality) and send me the file
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"kajones" wrote in message
...
Thanks,,,that helped with part of it. Now I have another problem. For
some
reason my graph points for the first three weeks show as zero. I am using
a
Vlookup to pull the data from another file. Is there something else that
I
need to do in my chart to make it show up correctly on the chart. If I go
back and type over the formula with just the number that it gives me it
works
okay.


--
keith jones


"Bernard Liengme" wrote:

For the weeks that you have no data, enter =NA(). This displays as #N/A
and
is ignored by the chart engine
Don't like this idea because it looks odd when you print your report? The
hide these entries with conditional format. Suppose the data is in
B2:B53,
select this range, use Format | Conditional Formatting and in dialog use
Formula Is ...=ISNA(B2) and set the font to the same colour as the cell's
background to make it invisible

Alternatively: click on chart then use Tools | Options | Charts and
specify
how empty cells are to be treated

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"kajones" wrote in message
...
How do I keep my chart line from dropping to zero for the upcoming
weeks
that
do not have data. I am using a formula to calculate my 52 week
progress.
The
chart graphs the weeks correctly that have data, but drops to zero for
the
upcoming weeks. I am trying to use a line graph.

Thanks,
--
keith jones

Solved: data was text not number
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"kajones" wrote in message
...
Thanks,,,that helped with part of it. Now I have another problem. For
some
reason my graph points for the first three weeks show as zero. I am using
a
Vlookup to pull the data from another file. Is there something else that
I
need to do in my chart to make it show up correctly on the chart. If I go
back and type over the formula with just the number that it gives me it
works
okay.


--
keith jones


"Bernard Liengme" wrote:

For the weeks that you have no data, enter =NA(). This displays as #N/A
and
is ignored by the chart engine
Don't like this idea because it looks odd when you print your report? The
hide these entries with conditional format. Suppose the data is in
B2:B53,
select this range, use Format | Conditional Formatting and in dialog use
Formula Is ...=ISNA(B2) and set the font to the same colour as the cell's
background to make it invisible

Alternatively: click on chart then use Tools | Options | Charts and
specify
how empty cells are to be treated

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"kajones" wrote in message
...
How do I keep my chart line from dropping to zero for the upcoming
weeks
that
do not have data. I am using a formula to calculate my 52 week
progress.
The
chart graphs the weeks correctly that have data, but drops to zero for
the
upcoming weeks. I am trying to use a line graph.

Thanks,
--
keith jones