LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamically change data in chart title Bill James Charts and Charting in Excel 2 January 9th 08 05:17 AM
How to set the chart height dynamically. ramkumar_cpt Charts and Charting in Excel 0 January 27th 06 12:03 PM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM
Scaling a chart that has been dynamically created in vb Mark Charts and Charting in Excel 3 May 27th 05 08:16 PM
Dynamically chart active row Patti Charts and Charting in Excel 7 April 4th 05 03:39 PM


All times are GMT +1. The time now is 10:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"