| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to ignore blank cells
I have a chart which pulls data from various worksheets. The data changes monthly, so each new month there are lots of blank cells which don't yet have values. But the chart continues on for the blank days, giving each a value of zero (even though the cells contains spaces, not zero). Is there an option to not chart data points when they're blank (or zero)? Thanks! -- MattBeckwith ------------------------------------------------------------------------ MattBeckwith's Profile: http://www.excelforum.com/member.php...o&userid=30571 View this thread: http://www.excelforum.com/showthread...hreadid=511363 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to ignore cells in ranking? | Excel Discussion (Misc queries) | |||
| Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
| how do you ignore blank cells | Excel Discussion (Misc queries) | |||
| Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
Threaded Mode
