Hi,
I have a workbook which has chart (as a separate sheet) and the data plotted
on this chart come from a worksheet.
I am using autofilter on this worksheet and my chart plots only the visible
cells.
The values in one of the columns on this worksheet is the name of my data. I
have added a textbox on the chart and i want it to display that name. The
only thing i found in help was this:
=wat_streamflow_Crosstab1!$A$2
This works but when i select a different name with the autofilter, the value
in the textbox remains the same (the value in cell A2).
What i want to do is when i select something else with my filter and the
visible data in the worksheet start from i.e A5430, the value in the textbox
to automaticly change to A5430.
Please help
--
Panos