Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ant
 
Posts: n/a
Default 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.


  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
How to auto-fill text based on text in another cell Jason Excel Discussion (Misc queries) 3 February 16th 05 08:40 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
returning a text cell based on a number cell Josh7777777 Excel Worksheet Functions 2 November 2nd 04 07:42 PM


All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"