If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I prevent Excel from plotting a cell w/ a formula as a "ze.
I am setting up a trend chart for 2005 and want to setup the chart now so
that it updates each week as data is added. The problem I am having is that the chart is plotting all future "result" cells as "zeros" because of the formula in each cell. I am blanking out all future "result" column cells w/ (IF) logic statements w/ the (ISBLANK) function so nothing appears in the cell until the right date, but its still being plotted as a zero. Is there a way to prevent Excel from plotting these "formula only" cells as "zeros"? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
Excel Formula - get cell's value which the cell reference is a text | tombudda | Worksheet Functions | 1 | July 8th, 2004 05:50 AM |
excel vba - clear contents of cell but not formula | chief | General Discussion | 3 | July 7th, 2004 01:35 AM |
Problem with formula using an answer of another cell formula | KIMBERLY | Worksheet Functions | 4 | April 23rd, 2004 08:15 PM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |