Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make a chart that ignores zero values
Hi All,
I found this spreadsheet on the net: http://spreadsheets.google.com/ccc?k...k_rZ_TXRU7KIg# It is a log for runners. The chart displays only the days that contain some data. Those are the days that a person did a run. I'm tried this on my own chart but it always comes up with the line dropping to zero value when no data was found on that day. How is this done? Regards Marco |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make a chart that ignores zero values
Hi,
Select the chart and then via Tools Options Chart Plot empty cells as Interpolated. But this will only may a difference if you cells are truly empty. If they contain formula or text that setting will have no effect. Instead you need to use NA() instead of "" Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Co" wrote in message ... Hi All, I found this spreadsheet on the net: http://spreadsheets.google.com/ccc?k...k_rZ_TXRU7KIg# It is a log for runners. The chart displays only the days that contain some data. Those are the days that a person did a run. I'm tried this on my own chart but it always comes up with the line dropping to zero value when no data was found on that day. How is this done? Regards Marco |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make a chart that ignores zero values
Plot from =IF((B40),(C4/B4),NA()) instead of =IF((B40),(C4/B4),"")
-- David Biddulph "Co" wrote in message ... Hi All, I found this spreadsheet on the net: http://spreadsheets.google.com/ccc?k...k_rZ_TXRU7KIg# It is a log for runners. The chart displays only the days that contain some data. Those are the days that a person did a run. I'm tried this on my own chart but it always comes up with the line dropping to zero value when no data was found on that day. How is this done? Regards Marco |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make a chart that ignores zero values
On 25 nov, 20:58, "David Biddulph" <groups [at] biddulph.org.uk
wrote: Plot from =IF((B40),(C4/B4),NA()) instead of *=IF((B40),(C4/B4),"") -- David Biddulph "Co" wrote in message ... Hi All, I found this spreadsheet on the net: http://spreadsheets.google.com/ccc?k...k_rZ_TXRU7KIg# It is a log for runners. The chart displays only the days that contain some data. Those are the days that a person did a run. I'm tried this on my own chart but it always comes up with the line dropping to zero value when no data was found on that day. How is this done? Regards Marco When I do this: =IF((B120);(C12/B12);NA()) I get an error in the empty field: #NAME? If I do this in the field: =IF((B120),(C12/B12),NA()) I get an error saying: Error in the formula. Marco |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make a chart that ignores zero values
NA() and #N/A may have a different representation in a non-English
localization of Excel. Look up the "Information Function" for an error that means "no value is available". and use this in your formula. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ --------------------------------- When I do this: =IF((B120);(C12/B12);NA()) I get an error in the empty field: #NAME? If I do this in the field: =IF((B120),(C12/B12),NA()) I get an error saying: Error in the formula. Marco |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA WHICH IGNORES POSITIVE VALUES | New Users to Excel | |||
Solver Ignores Constraints | Excel Discussion (Misc queries) | |||
How can I make my chart update the new values from database? | Charts and Charting in Excel | |||
Min Value using array ignores Zero | Excel Discussion (Misc queries) | |||
Autosum ignores cell values | Excel Worksheet Functions |