Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Have a chart line completely disappear for a Series...
I would like during certain situations to have a Chart line (Series)
completely disappear rather than show along the zero line. Wen I clear a value with the delete key that cell does not show on the chart. What character do I move to a cell to have that occur during the operation of a spreadsheet. With the IF function I have moved in a null ("") and that doesn't work. I have tried a blanks (" ") and that doesn't work. If I use the delete key from the keyboard that does work. How to I set a cell to that "delete key" value? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Have a chart line completely disappear for a Series...
Try:
=NA() -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Setts" wrote in message ... I would like during certain situations to have a Chart line (Series) completely disappear rather than show along the zero line. Wen I clear a value with the delete key that cell does not show on the chart. What character do I move to a cell to have that occur during the operation of a spreadsheet. With the IF function I have moved in a null ("") and that doesn't work. I have tried a blanks (" ") and that doesn't work. If I use the delete key from the keyboard that does work. How to I set a cell to that "delete key" value? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
Refreshing pivot makes second data series line disappear from chart !!! | Excel Discussion (Misc queries) | |||
Line chart with two series; how to add points to one and not the other? | Charts and Charting in Excel | |||
ordering series one completely after each other (multiple X-axis?) | Charts and Charting in Excel | |||
How do I force a series in a Bar-Line Chart to be a Bar? | Charts and Charting in Excel |