Automatic update of date field in Chart Title?

[PolarBear]

Hi,

I'd like to update the date in a chart title automatically,
i.e. instead of manually going in to change "Sales Update November 3"
to "Sales Update November 4", just have excel do it for me.

Any thoughts?

Thanks,

Kevin

 

[Von Pookie]

You may have to change the chart it's referring to, but this should work:

Charts(1).ChartTitle.Characters.Text = "Sales Update " & Format(Date,"mmmm d")

 

[tusharm]

No need for VBA.

Create the title in a worksheet cell. Then link the chart title to the worksheet cell. For how, see
Dynamic Chart Title
http://www.tushar-mehta.com/excel/newsgroups/dynamic_chart_title/index.html

Hi,

I'd like to update the date in a chart title automatically,
i.e. instead of manually going in to change "Sales Update November 3"
to "Sales Update November 4", just have excel do it for me.

Any thoughts?

Thanks,

Kevin

 

[Von Pookie]

Oh. Duuuh, Kristy.

...it's going to be a long day, at this rate.

 

[tusharm]

Don't be too hard on yourself. On this site VBA is the first tool most people reach for.

It's unfortunate because there is so much that can be done without it and all its attendant issues. If you really want to push the envelope with XL check out the the XL newsgroups. Or, visit the sites of various MS MVPs. A non-exhaustive list: Bullen, Walkenbach, Pope, Pearson, Peltier, and myself.

Oh. Duuuh, Kristy.

...it's going to be a long day, at this rate.

 

[PolarBear]

Thanks Tusharm for the assistance, and thanks Kristy for the suggestion. I should have specified I wasn't using a macro to create the chart.

cheers,

Kevin