Inserting live formula into plot area
 

I want to insert a formula , such as = today(), in the plot area of a bar
chart. How do I do this?

Inserting live formula into plot area
 

Enter the formula in a worksheet cell
Activate the chart; type = in the formula bar; click on the cell with
formula
This give something like =Sheet1!D1, tap Enter key or clicks the formula
bar's green check mark
Now you have a text box in the chart and it displays the formula.
You can drag the textbox anywhere on the chart
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Navy Guy" wrote in message
...

I want to insert a formula , such as = today(), in the plot area of a bar
chart. How do I do this?

Inserting live formula into plot area
 

Hi,

You can use Bernard's technique with chart and axis titles to make them
dynamic. In other words to have the chart title display the current date you
would single click the title, click on the formula bar, type = and then click
on the cell in the spreadsheet where the =TODAY() or =NOW() function was
located.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Navy Guy" wrote:


I want to insert a formula , such as = today(), in the plot area of a bar
chart. How do I do this?

Inserting live formula into plot area
 

Bernard -- thanks a lot. The procedure was easy to apply and worked as
advertised!