View Single Post
  #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.