If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Graph points going to zero
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 |
#2
|
|||
|
|||
Graph points going to zero
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 |
#3
|
|||
|
|||
Graph points going to zero
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 |
#4
|
|||
|
|||
Graph points going to zero
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 |
#5
|
|||
|
|||
Graph points going to zero
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 |
Thread Tools | |
Display Modes | |
|
|