Require to enter sum of varying values in a text box in the chart area.

Are there any formula or other methods to do this.

Thank you Berni

Activate/click the chart.
In the formula bar enter "=" (an equal sign without the quote marks)
Click the cell that contains the total you want to display.
Press the Enter key.
That will create a textbox (with the cell value) located somewhere on the chart.
Drag the textbox as desired.

Note: the above probably won't work in XL2007.
However, you do have the ribbon to look at. <g
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"berniwalk"
wrote in message
Require to enter sum of varying values in a text box in the chart area.
Are there any formula or other methods to do this.
Thank you Berni

In 2007 you can create the textbox explicitly, then select it, click in the
formula bar, type "=", and click on the desired cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim Cone" wrote in message
...

Activate/click the chart.
In the formula bar enter "=" (an equal sign without the quote marks)
Click the cell that contains the total you want to display.
Press the Enter key.
That will create a textbox (with the cell value) located somewhere on the
chart.
Drag the textbox as desired.

Note: the above probably won't work in XL2007.
However, you do have the ribbon to look at. <g
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"berniwalk"
wrote in message
Require to enter sum of varying values in a text box in the chart area.
Are there any formula or other methods to do this.
Thank you Berni