formula to calculate values displayed in a chart
 

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

formula to calculate values displayed in a chart
 

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

formula to calculate values displayed in a chart
 

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