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
|
|||
|
|||
Trendline to ignore empty cells
I have a chart with current sales and future sales. In the future cells I
have =NA() to ignore them because they are empty until a future date. Because of this my trendline does not fall to zero but the trendline still shows. Is their a way to make the trendline not show at all for those empty cells but then show at the end for the total average sales? Thanks for your help! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Counting empty cells within a range of cells | Rosehill - ExcelForums.com | New Users | 0 | April 7th, 2005 12:47 AM |
AVERAGE COLUMNS BUT NOT COUNT EMPTY CELLS | Harald Staff | Worksheet Functions | 3 | January 19th, 2004 05:55 PM |