Text on cart based on data in a cell

A

Ant

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.
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inside Base Series Label Showing #N/A 0
Pivot table chart problem, How to show different subtotal levels 2
Best way to limit data for chart? 1
Excel Changing chart label colors based on a value in a cell 0
how do I show filter information on a pivot chart in excel2007? 3
Filtering data for scatter plot with chart labels 2
Connecting two series in a scatter chart - Excel 2007 4
Remove series from Pivot Chart 2

Top