View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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