conditional hide

[jim3975]

Hi,
I have a graph in which I plot the date against a variable that changes
every day. (Otherwise it wouldn't be a variable, heh.) Actually the variable
is used in a formula and the outcome of that is used in the graph. I have
copied the formula through the whole row and this leads to meaningless data
after today. How do I (automatically & conditionally) hide these meaningless
data in the sheet and in the graph as well?

Thanks in advance.

Jim

 

[Pete_UK]

Perhaps you can make use of a dynamic range for your graph - Chip
Pearson explains how here:

http://www.cpearson.com/excel/excelF.htm#DynamicRanges

In calculating the formula which feeds the graph, you could have
something like this:

=IF(date_cell>TODAY(),"",your_current_formula)

Hope this helps.

Pete

 

[jim3975]

OK, thanks a lot.

Perhaps you can make use of a dynamic range for your graph - Chip
Pearson explains how here:

http://www.cpearson.com/excel/excelF.htm#DynamicRanges

In calculating the formula which feeds the graph, you could have
something like this:

=IF(date_cell>TODAY(),"",your_current_formula)

Hope this helps.

Pete

 

[Pete_UK]

Glad to be of help.

Pete

OK, thanks a lot.






- Show quoted text -

 

[jim3975]

A bit late, but: Thanks.

Perhaps you can make use of a dynamic range for your graph - Chip
Pearson explains how here:

http://www.cpearson.com/excel/excelF.htm#DynamicRanges

In calculating the formula which feeds the graph, you could have
something like this:

=IF(date_cell>TODAY(),"",your_current_formula)

Hope this helps.

Pete