Annotating Excel 2007 Chart

[abyss478]

Hi guys,

I'm trying to add a text box to a chart (in Excel 2007), which refers to a cell in the sheet. I have some calculated numbers (standard deviation & total count) and I'd like to display them on the chart; but I can't seem to figure it out.

Basically, what I'd like to have on the chart is a text box and something like:

"Mean = " = CELL_REFERENCE

Where CELL_REFERENCE is a number I've stored in a cell. Any ideas how to go about doing this?

Any help at all would be greatly appreciated.
Thanks.

 

[Andy Pope]

Assuming you have chart data in B1:B4 you would calculate the mean using a formula in C1.
Then in D1 you can build the text you want displayed via the linked and embeded textbox.

D1: ="Mean=" & C1

Embed the textbox within the chart. Select the textbox object, then via the formula bar enter the formula

=Sheet1!D1

changing sheet1 to the appropriate sheetname.

 

[abyss478]

Hi Andy,

Great that worked flawlessly!!

Thanks again, it's really apprecaiated...