Chart Title Using Autofilter Selection
Hi,
Single click the chart title, then click the Formula Bar, type = and click
the cell in the spreadsheet where the filter criteria is displayed. Press
enter.
If you want the title to be a little bit more dynamic, for example you pick
a month from a filter and you want to display "Budget as of July"
The create a cell in the spreadsheet with a formula like
="Budget as of "&A1
Where A1 is the filter drop down result. Then use the original approach to
link the title to this cell with the formula.
If the cell A1 returned a date like 12/1/2008 then your formula would become
a little more complicated:
="Budget as of: "&TEXT(A1,"M/D/YYYY")
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Roger" wrote:
I have a simple line chart based on the the data displyed from using
Autofilter. I select only one criteria at time to display. I want to link
the chart title to the filtered criteria. So when I choose a different
filter the chart title will change to the new filter. Is there an easy way
to accomplish this?
Thanks,
Roger
BTW, I have both XL 2003 & XL 2007.
|