Thread: Text on cart based on data in a cell

I have a chart on a separate sheet witch is based on a filtered list on
another sheet. I would like to label my chart to show witch filter as been
applied, is this possible? (Ho, and if so, how would I do it?)

Thanks for any help.

Select the chart, press the equal key, then select the cell with a
mouse. This adds a text box in the middle of the chart, which you can
move around and format as needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Ant wrote:

> I have a chart on a separate sheet witch is based on a filtered list on
> another sheet. I would like to label my chart to show witch filter as been
> applied, is this possible? (Ho, and if so, how would I do it?)
>
> Thanks for any help.
>
>