May be this will help. You can link a text box to a cell's contents. G
to the chart. Click the formula bar and type '=SheetName!Cellname' an
the text box will show the cells contents. Alternately you could type
in the formula bar and select the cell you want to see on the chart.
Actually, you just need to select the chart (the plot area or chart area), type =
without bothering to click in the formula bar, then click on the cell.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
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.
