Home |
Search |
Today's Posts |
#1
|
|||
|
|||
to stop zero from showing on graph
I have graphs for which values will be filled in time, but befor it's filled
I want zeroes not to be visible. Is it posible? |
#2
|
|||
|
|||
Hi,
Either leave the cells empty or use =NA() Cheers Andy natash@ wrote: I have graphs for which values will be filled in time, but befor it's filled I want zeroes not to be visible. Is it posible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
I didn't write the original post but am having the same problem. This works
if I remove all content from the cell - however - I would like to have a formula in the cell so that it automatically populates with data from another cell in the worksheet - when that cell has data entered - so is there a formula that will enable me to capture the data from another cell after it is entered but still make the cell appear to be empty until then? Otherwise it puts all zeroes in the graph until data is entered. Thanks for your help. Kathie Meier "Andy Pope" wrote: Hi, Either leave the cells empty or use =NA() Cheers Andy natash@ wrote: I have graphs for which values will be filled in time, but befor it's filled I want zeroes not to be visible. Is it posible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
Hi,
You need to include a IF condition in you formula. =IF(X1<"",X1,NA()) So if the other cell, in this case X1, has a value use it otherwise use the NA() Cheers Andy Brrnese wrote: I didn't write the original post but am having the same problem. This works if I remove all content from the cell - however - I would like to have a formula in the cell so that it automatically populates with data from another cell in the worksheet - when that cell has data entered - so is there a formula that will enable me to capture the data from another cell after it is entered but still make the cell appear to be empty until then? Otherwise it puts all zeroes in the graph until data is entered. Thanks for your help. Kathie Meier "Andy Pope" wrote: Hi, Either leave the cells empty or use =NA() Cheers Andy natash@ wrote: I have graphs for which values will be filled in time, but befor it's filled I want zeroes not to be visible. Is it posible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
It works, gratefully natash@
"Andy Pope" wrote: Hi, You need to include a IF condition in you formula. =IF(X1<"",X1,NA()) So if the other cell, in this case X1, has a value use it otherwise use the NA() Cheers Andy Brrnese wrote: I didn't write the original post but am having the same problem. This works if I remove all content from the cell - however - I would like to have a formula in the cell so that it automatically populates with data from another cell in the worksheet - when that cell has data entered - so is there a formula that will enable me to capture the data from another cell after it is entered but still make the cell appear to be empty until then? Otherwise it puts all zeroes in the graph until data is entered. Thanks for your help. Kathie Meier "Andy Pope" wrote: Hi, Either leave the cells empty or use =NA() Cheers Andy natash@ wrote: I have graphs for which values will be filled in time, but befor it's filled I want zeroes not to be visible. Is it posible? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
New data in table not showing in graph | Excel Discussion (Misc queries) | |||
Stop % showing in outcome of formula | Excel Worksheet Functions | |||
Graph Axes | Excel Discussion (Misc queries) | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |