Chart title that changes dynamically?

  • Thread starter Thread starter Arlen
  • Start date Start date
A

Arlen

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
 
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).
 
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.
 
Got it, fellas!

Thanks to both of you.

Arlen

Arvi Laanemets said:
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<at>tarkon.ee )


Arlen said:
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
 
Thanks for the feedback. Don't forget to check the Yes box :)
--
John C


Arlen said:
Got it, fellas!

Thanks to both of you.

Arlen

Arvi Laanemets said:
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<at>tarkon.ee )


Arlen said:
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
 
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 said:
Thanks for the feedback. Don't forget to check the Yes box :)
--
John C


Arlen said:
Got it, fellas!

Thanks to both of you.

Arlen

Arvi Laanemets said:
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<at>tarkon.ee )


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
 
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 said:
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 said:
Thanks for the feedback. Don't forget to check the Yes box :)
--
John C


Arlen said:
Got it, fellas!

Thanks to both of you.

Arlen

:

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<at>tarkon.ee )


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
 
Back
Top