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.