Today's date in Chart

[Jeff]

I created a dynamic gantt chart in Excel 2007 which changes based on the
current date "=TODAY()".

Is there a way to have the current date automatically appear somewhere
in the produced bar chart as a "legend"?

Thanks.

 

[Dave Peterson]

I tested this in xl2003, so you'll have to retest...

I added a textbox from the Drawing toolbar into my chart.

With the textbox selected, I typed:
=a1
in the formula bar

Then I typed:
=today()
in A1

And it seemed to work ok. I changed the numberformat to other date formats and
that was reflected in my textbox in the chart, too.

 

[Jeff]

You're lucky to be in Excel 2003. I'm seriously thinking of
re-installing my Excel 2002.

Thanks, but unfortunately, I had already tried that in My Excel 2007 but
when I do, I get a popup error box that says:
"References in object formulas must be external references to worksheets"
So, I'm still stuck.

 

[Don Guillett]

I just went to xl2007 and did this. However, I did it BEFORE I moved the
shape into the area of the chart

 

[Dave Peterson]

I could add a textbox from the Insert Tab of the ribbon to the worksheet.
Assign it the formula and drag it over the chart.

Maybe that would work ok for you.

 

[Jeff]

I just went to xl2007 and did this. However, I did it BEFORE I moved the
shape into the area of the chart

That was it. Worked for me too.

Thank you all. You are great.

 

[Jeff]

I could add a textbox from the Insert Tab of the ribbon to the worksheet.
Assign it the formula and drag it over the chart.

Maybe that would work ok for you.

That is what did it. Of course when I print the chart, the text box did
not print with it. But I go around that by saving it as a pdf before
printing and that kept the text box.

Again, thank you all.

Jeff

 

[Don Guillett]

text box properties PRINT

 

[Jeff]

text box properties PRINT

You're wonderful.

Thank you.