| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace zeros with nulls
Can someone tell me how I could not plot null cells in the middle of a large range of data? To make myself a bit clearer- for example let's say I have data from A1 to A10000 in which some cells are blank cells and I would like to plot A1-A10,000 against B1- B10,000 BUT excel seems to plot the blank cells in either columns as zeros in the graph! Is there anyway I could get excel to just let the null cells be null cells isntead of making them zeros? Thanks in advance -- dharshanie ------------------------------------------------------------------------ dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673 View this thread: http://www.excelforum.com/showthread...hreadid=528512 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace zeros with nulls
Pull-down:
Data filter Autofilter and select Non-blanks in both columns -- Gary's Student "dharshanie" wrote: Can someone tell me how I could not plot null cells in the middle of a large range of data? To make myself a bit clearer- for example let's say I have data from A1 to A10000 in which some cells are blank cells and I would like to plot A1-A10,000 against B1- B10,000 BUT excel seems to plot the blank cells in either columns as zeros in the graph! Is there anyway I could get excel to just let the null cells be null cells isntead of making them zeros? Thanks in advance -- dharshanie ------------------------------------------------------------------------ dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673 View this thread: http://www.excelforum.com/showthread...hreadid=528512 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace zeros with nulls
Thank You!!! That's great-will have a go. -- dharshanie ------------------------------------------------------------------------ dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673 View this thread: http://www.excelforum.com/showthread...hreadid=528512 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace zeros with nulls
Thank You!!! That's great-will have a go. -- dharshanie ------------------------------------------------------------------------ dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673 View this thread: http://www.excelforum.com/showthread...hreadid=528512 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace zeros with nulls
This is a nice one to keep in your mental toolbox. If you want to display
the fact that data is missing, then leave the blanks in. If you want better looking plots, then filter them out. -- Gary's Student "dharshanie" wrote: Thank You!!! That's great-will have a go. -- dharshanie ------------------------------------------------------------------------ dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673 View this thread: http://www.excelforum.com/showthread...hreadid=528512 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace zeros with nulls | Excel Discussion (Misc queries) | |||
| Replace #DIV/0 error with zeros | Excel Discussion (Misc queries) | |||
| replace values with zeros | Excel Discussion (Misc queries) | |||
| How can I replace zeros with blank spaces during calculations plea | Excel Worksheet Functions | |||
| Using Excel, how do I replace cells containing blanks with nulls? | Excel Discussion (Misc queries) | |||
Hybrid Mode
