Home |
Search |
Today's Posts |
#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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I get excel to ignore blank cells in formulas | Excel Worksheet Functions | |||
Eliminate empty cells in data range | Excel Discussion (Misc queries) | |||
data in empty cells | Excel Worksheet Functions | |||
Excal Concatination of cells that are not empty | Excel Worksheet Functions | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) |