Current date (i.e., today()) in Chart Title

S

Shane Devenshire

Hi,

In a cell, say A1, in the spreadsheet enter a formula like this:

=TEXT(TODAY(),"M/D/YY")

Now select the border of the chart title, not inside, and type =A1
when you press enter the title will use the value in cell A1 for your title.
 
G

Gwynne

Shane, I did exactly what your answer said and it worked great! However, the
Date is now the entire title of my chart what is not exactly what I need. I
need the title "WIA Disbursement and and Budget Summary - June 17, 2009".
Can you help with this?

Thanks#
 
A

Andy Pope

Just combine the text with the formula Shane provided.

A1:="WIA Disbursement and and Budget Summary - " & TEXT(TODAY(),"MMMM D,
YYYY")

Cheers
Andy
 
M

Maple

Hi,

I felt so lucky that someone had answers for exactly what I want to do.
But, I still have some issues in following your steps.

I entered the date in cell A1. Then, I clicked the border of the Chart
Title. But, where should I type "=A1"?

I typed "A1" into the function box (Fx) but an error message occur.

"The formula you typed contains an eorr. Try one of the following:
-Make sure you've included all parentheses and requred arguments
-To get assistance iwth using a function, click Function (Insert Menu)
....
....

Did I type the "=A1" in wrong place?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
Date in Chart Title 2
Dynamic Chart Title With 3D Stacked Column Chart 2
second Chart Title 2
Variables in Chart titles? 7
Office 07 Excel chart title position 1
Setting chart title. 1
Replacing Chart title with Text box 2

Top