| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i keep cells with a formula returning "" from being plotted
I have a chart that referrences cells that contain an IF statement that
returns "". Although the chart option 'do not plot blank cells' is marked, Excel graphs these cells as being 0. |
|
#2
|
|||
|
|||
|
Hi,
Instead of "" use NA() Cheers Andy TBB wrote: I have a chart that referrences cells that contain an IF statement that returns "". Although the chart option 'do not plot blank cells' is marked, Excel graphs these cells as being 0. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
unfortunately "" will plot as a zero
#NA will plot as interpolated with no symbol if you do not want to be able to use the Do not plot at all aspect, what I have done is make the cells I dont' want to plot be a uniques character, copy the data select all paste special values somewhere else. use find replace and relaplace the unique characer with nothing. Then plot this data. "TBB" wrote: I have a chart that referrences cells that contain an IF statement that returns "". Although the chart option 'do not plot blank cells' is marked, Excel graphs these cells as being 0. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
| pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) | |||
| How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
| How do i select different cells to be use in a formula. | Excel Discussion (Misc queries) | |||
| How do I set up a formula to repat 5 consecutive cells in a colum. | Excel Worksheet Functions | |||
Linear Mode
