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.
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.