Filter Choice in Chart Title

[kcrippe1]

Is there a way to reference a filter choice in a chart title? I have
a column with about 7 validsets. If the user choses one of those, I
would like the choice to be displayed in an associated chart title. I
understand that I can reference a cell in the chart title, so really
the question is; How do I reference a selected filter choice in
another cell?

Unfortunately I can't use pivots for this, since the chart is an XY
scatter.

Thanks,
Kevin

 

[Don Guillett]

You could use this UDF in a cell. Put the code in a REGULAR module and type
=st() somewhere.

Function st()
x = Cells(Rows.Count, "b").End(xlUp).Row
st = Cells(x, "b")
End Function

 

[kc]

Brilliant! Thank you!

 

[Don Guillett]

glad it helped

 

[kc]

Ok - so now I notice that the result doesn't calculate after another
filter choice.

How can I force a calculation of this cell after a filter choice has
been made?

 

[Don Guillett]

When I tested it, it did. Just add this as the FIRST line of the function

application.volatile

 

[kc]

Not sure what that does, but it works. Thanks again!