Chart title that changes dynamically?
 

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

Chart title that changes dynamically?
 

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

Chart title that changes dynamically?
 

Unfortunately, you cannot use a 'named' reference, so you would have to have
a cell somewhere you can 'dedicate' to the name. In my workbooks, I usually
have a tab devoted to Tables, and that would be a good place for it.
Somewhere, say in cell A3 of your Table tab, you have the formula:

="Tacoma Bulk"&CHAR(10)&TEXT(MIN(Main!$E$2,Main!$E$3),"mm/dd/yy")&" to
"&TEXT(MIN(Main!$E$2,Main!$E$3),"mm/dd/yy"

This assumes your 2 dates reside in your 'Main' tab in cells E2 and E3

Then, go to your chart Source Data, and in the name field you would type:

=Table!$A$3

Modify as needed, hope this helps.



--
John C


"Arlen" wrote:

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

Chart title that changes dynamically?
 

Got it, fellas!

Thanks to both of you.

Arlen

"Arvi Laanemets" wrote:

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

Chart title that changes dynamically?
 

Thanks for the feedback. Don't forget to check the Yes box :)
--
John C


"Arlen" wrote:

Got it, fellas!

Thanks to both of you.

Arlen

"Arvi Laanemets" wrote:

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

Chart title that changes dynamically?
 

I know I forgot that.

But HEY, while you're still here, how do you create a subtitle field below
the main title?

This one is probably easy to find online, but I just thought I'd ask.

Anyway, have a great day

Arlen

"John C" wrote:

Thanks for the feedback. Don't forget to check the Yes box :)
--
John C


"Arlen" wrote:

Got it, fellas!

Thanks to both of you.

Arlen

"Arvi Laanemets" wrote:

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

Chart title that changes dynamically?
 

Well, you could add another CHAR(10)&"subtitle" if you want, or you could put
subtitle information in Table!$A$4, and then have the Chart Name in Source
Data pointing to Table!$A$3:$A$4
--
John C


"Arlen" wrote:

I know I forgot that.

But HEY, while you're still here, how do you create a subtitle field below
the main title?

This one is probably easy to find online, but I just thought I'd ask.

Anyway, have a great day

Arlen

"John C" wrote:

Thanks for the feedback. Don't forget to check the Yes box :)
--
John C


"Arlen" wrote:

Got it, fellas!

Thanks to both of you.

Arlen

"Arvi Laanemets" wrote:

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