N
Navy Guy
I want to insert a formula , such as = today(), in the plot area of a bar
chart. How do I do this?
chart. How do I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
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
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
S
Shane Devenshire
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.
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.
N
Navy Guy
Bernard -- thanks a lot. The procedure was easy to apply and worked as
advertised!
advertised!