Dynamic text box in a chart?

Posts: 218
Joined: 02 Feb 2010, 23:10

Dynamic text box in a chart?

Post by Teunis »

I know how to create a dynamic chart title in Excel. But is it possible to create a dynamic text box in a chart which contains changing information and is updated automatically? E.g. a box should contain "Maximum = xx.xx", whereby xx.xx is automatically updated/calculated from a source series in the workbook.



User avatar
Posts: 78370
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Dynamic text box in a chart?

Post by HansV »

In a cell (which may be hidden behind the chart), enter the formula that returns the text you want to display, e.g.

="Maximum = " & TEXT(MAX(A1:A10),"0.00")

Let's say the cell with the formula is D2 on Sheet1.
Click on the chart and type =Sheet1!D2
Press Enter.
You now have a text box on the chart that displays the value of the cell.
You can drag the text box to the desired position, change its formatting etc.
Best wishes,