Graph points going to zero

[kajones]

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,

 

[Bernard Liengme]

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

 

[kajones]

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.

 

[Bernard Liengme]

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 Liengme]

Solved: data was text not number