Hi

Enter into some cell on worksheet the formula, which composes wanted title
text. (You may want to hide the column or row with the formula later, so
choose the cell considering this.);
Activate the current title on your chart, and then activate the formula bar;
Enter the reference to cell with composed header text into formula bar, and
press Enter;
(Optionally hide the row or column with formula).


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Arlen" wrote in message
...
Hello, Folks!

I have created that changes on the fly based on the date range a user
wants
to chart.

Is it possible to include a title field at the top of the chart that
imports
the Start and End date so we don't have to type it by hand whenever we
view
or print different ranges?

Something like
Tacoma Bulk
&[=Min(A1,B1)] to &[=Max(A1,B1)]

Thanks for your time.

Arlen