Filter Choice in Chart Title

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

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
<kcrippe1@email.mot.com> wrote in message
news:1136994602.961680.74710@g43g2000cwa.googlegroups.com...
> 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
>

Brilliant! Thank you!

glad it helped


--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"kc" <kcrippe1@email.mot.com> wrote in message
news:1136998679.263583.281120@z14g2000cwz.googlegroups.com...
> Brilliant! Thank you!
>

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?

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

application.volatile

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"kc" <kcrippe1@email.mot.com> wrote in message
news:1137005862.465464.149680@g44g2000cwa.googlegroups.com...
> 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?
>