Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting null values
I have a chart that is plotting null values. I tried the formula
=if(C25="",N/A(),Sum(C22:C25)). I've also deleted the formula to create a completely null cell. I've been to Tools, Options, Chart and selected Plot empty cells as Not plotted, zero and Interpollated As well as turning Plot Visible Cells only (turned it on and off) Nothing seems to make a difference. Any suggestions? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting null values
Stephanie, what kind of chart are you using? Can you give an example of how
your data table looks like? br, Henk "StephanieH" wrote: I have a chart that is plotting null values. I tried the formula =if(C25="",N/A(),Sum(C22:C25)). I've also deleted the formula to create a completely null cell. I've been to Tools, Options, Chart and selected Plot empty cells as Not plotted, zero and Interpollated As well as turning Plot Visible Cells only (turned it on and off) Nothing seems to make a difference. Any suggestions? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting null values
Here's the data table:
2003 2004 2005 2006 1st QTR $480,225.57 $728,453.06 $666,902.66 $637,340.65 2nd QTR $541,123.51 $899,090.95 $711,704.53 $176,706.39 3rd QTR $490,729.23 $314,911.38 $882,595.19 4th QTR $551,334.47 $386,755.70 $691,980.60 It is a Line Graph "HEK" wrote: Stephanie, what kind of chart are you using? Can you give an example of how your data table looks like? br, Henk "StephanieH" wrote: I have a chart that is plotting null values. I tried the formula =if(C25="",N/A(),Sum(C22:C25)). I've also deleted the formula to create a completely null cell. I've been to Tools, Options, Chart and selected Plot empty cells as Not plotted, zero and Interpollated As well as turning Plot Visible Cells only (turned it on and off) Nothing seems to make a difference. Any suggestions? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting null values
Stephanie:
I tried to mimick yr chart with Q1-Q4 on the X-axis. If yr chart contains 0 or #N/A in Q3/Q4 the line for 2006 shows zero values for 2006 Q3/Q4 but if you set Tools/Options/Chart Plot empty cells as "Plot nothing (leave gaps)" you should only get plots for Q1 and Q2. I am unable to reproduce yr problem (sorry). As an alternative, you may try to enter yr series for the running year (in this case 2006) as a dynamic named range with the OFFSET command. Instructions for this in many posts on this forum or e.g. http://www.ozgrid.com/Excel/DynamicRanges.htm (just first hit on Google; there are many many more). I hope this helps. GL, Henk "StephanieH" wrote: Here's the data table: 2003 2004 2005 2006 1st QTR $480,225.57 $728,453.06 $666,902.66 $637,340.65 2nd QTR $541,123.51 $899,090.95 $711,704.53 $176,706.39 3rd QTR $490,729.23 $314,911.38 $882,595.19 4th QTR $551,334.47 $386,755.70 $691,980.60 It is a Line Graph "HEK" wrote: Stephanie, what kind of chart are you using? Can you give an example of how your data table looks like? br, Henk "StephanieH" wrote: I have a chart that is plotting null values. I tried the formula =if(C25="",N/A(),Sum(C22:C25)). I've also deleted the formula to create a completely null cell. I've been to Tools, Options, Chart and selected Plot empty cells as Not plotted, zero and Interpollated As well as turning Plot Visible Cells only (turned it on and off) Nothing seems to make a difference. Any suggestions? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting null values
Hi,
Is this a typo? =if(C25="",N/A(),Sum(C22:C25)) as it should be =if(C25="",NA(),Sum(C22:C25)) Cheers Andy StephanieH wrote: I have a chart that is plotting null values. I tried the formula =if(C25="",N/A(),Sum(C22:C25)). I've also deleted the formula to create a completely null cell. I've been to Tools, Options, Chart and selected Plot empty cells as Not plotted, zero and Interpollated As well as turning Plot Visible Cells only (turned it on and off) Nothing seems to make a difference. Any suggestions? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you stop excel from charting empty cells/null values as zer | Charts and Charting in Excel | |||
Null values in charts and how to override the goal seek functionality | Charts and Charting in Excel | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
return a " " for null values | Excel Worksheet Functions | |||
Charting time? help please... | Charts and Charting in Excel |