Record a macro while doing the following

(start with chart not selected and on a different sheet)

Select the chart title
Put the cursor in the input bar and type
"=" followed by reference to the cell

You need to include the entire string in the cell, IOW you cannot combine
cell text with some other text. If necessary put the date in one cell and
link to another that includes the date cell & other text.

This is one of the very few occasions in VBA you actually need to use
..Select

Regards,
Peter T

"nbaj2k" wrote in
message ...

I have a macro and I'm creating a bar graph chart. In the chart title,
I want it to include the date that I have in a specific cell. Is there
a way to call on that in the title?

Basically I have a date range that I will type in and it will create a
chart, but I want the date range to be automatically part of the chart
title.

I know this has to be possible, I've been messing around with the code,
haven't quite gotten it to work yet.

Anyone have any idea?

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile:
http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=564244