LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
KR
 
Posts: n/a
Default need a refresher: text boxes on charts that use relational formulas?

I could have sworn that a long time ago, I set up one or more text boxes on
a graph that had formulas in them, so the text that was showing would
automatically change each month.

I'm now using Win2000/XL2003, and not having much luck- I want to put my
legend on the bottom, then a text box under it where I will show 3 values
(one for each legend item) to provide some additional information on the
graph. I have too many graphs to do this and have to update it all manually.

What is the best approach to use, to link the contents of my text box (or
similar) to the contents of a cell that on my sheet?

Thanks!
Keith

--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.


 
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
HOW DO I CORRECT A CONDITION IN WHICH ALL FORMULAS ACT LIKE TEXT? CHERYLZ Excel Worksheet Functions 1 June 22nd 05 12:58 AM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
FORMULAS IN CHARTS? xl2000 MGOETZ Charts and Charting in Excel 0 May 24th 05 06:48 PM
Is it possible to display text in charts? Janine Charts and Charting in Excel 1 May 11th 05 08:06 PM
Text Boxes Graham Parkinson Excel Discussion (Misc queries) 2 December 2nd 04 05:01 PM


All times are GMT +1. The time now is 02:49 AM.

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

About Us

"It's about Microsoft Excel"