LinkBack URL
About LinkBacks
I need to insert todays date in a chart title. How can I make a dynamic chart title?
I am able to included todays date by using a custom header but wish to have a dynamic chart title.
I need to insert todays date in a chart title. How can I make a dynamic chart title?
I am able to included todays date by using a custom header but wish to have a dynamic chart title.
Click on star (*) below if this helps
Hi
I don’t think it is possible to have a dynamic formula in the chart title except one that links it to a cell.
You can either link the chart title to a cell with your formula, eg
In cell F1 type the formula:
And set your chart title formula to
Please Login or Register to view this content.
Or you could use a macro something like this:Please Login or Register to view this content.
Please Login or Register to view this content.
When I set the chart title to =Sheet1!$F$1, what I get is =Sheet1!$F$1. Excel does not try to evaluate it
After clicking on the title, you need to enter =Sheet1!$F$1 in the formula bar
Life's a spreadsheet, Excel!
Say thanks, Click *
If I want today's date how does the macro below work?
Also I wish to have a two line title for the graph. Don't think this helpsPlease Login or Register to view this content.
After clicking on the title, you need to enter =Sheet1!$F$1 in the formula bar
Still doesn't work
Hi
A macro can add a two-line title if you like:
Sub chart_title()
ActiveChart.ChartTitle.Formula = "Chart of Widgets" & chr(13) & "Data For " & Format(Date, "dd/mmm/yy")
End Sub
or, if you are linking to a cell, add a line break by using a formula like this in your source cell:
Please Login or Register to view this content.
Link chart title.
http://www.andypope.info/tips/tip001.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks