software

I have a workbook with one data sheet and several charts which represent
weekly activity. I want to be able to pick up the title of the charts from
the spreadsheet, e.g. quot;Sales Activity for Week Ending April 7, 2006quot;. This
title information is contained in a cell in the spreadsheet.

How do I get it to display at the top of each chart without having to
manually type it in the title area under Chart Options?

Wilfred:

Here' a link to a post I have on dynamic titles that sounds like what you
are looking for.

processtrends.com/pg_chart_dy...hart_title.htm

I use a text box and link the box to the chart by activating chart,
entering quot;=quot; in formula bar then pointing to source cell.

You can format the text and place where you want on the chart. As an aside,
I prefer this text box approach to using Excel's chart title option. I find
the chart title option takes up more space than is necessary for the title.

As the source cell is updated, the title will automatically be updated.

One last point, you can use a concatenation formula to make your source cell
update as your week changes.

Your source title could be = quot;Sales Activity for Week Ending quot; amp;
Text(A1,quot;mmmm d, yyyyquot;). Substitute the actual date cell for A1 in this
example....Kellyquot;Wilfredquot; gt; wrote in message
. ..
gt;I have a workbook with one data sheet and several charts which represent
gt;weekly activity. I want to be able to pick up the title of the charts from
gt;the spreadsheet, e.g. quot;Sales Activity for Week Ending April 7, 2006quot;. This
gt;title information is contained in a cell in the spreadsheet.
gt;
gt; How do I get it to display at the top of each chart without having to
gt; manually type it in the title area under Chart Options?
gt;
gt;
gt;
Kelly O'Day, I have three words for you: Awesome, awesome, awesome!!!

Sometimes I post to these newsgroups and get so many tangential replies that
I wonder if it's worth the effort of composing a question. Your answer was
1000% on the mark! Thank you so much. Thanks also for the example. I've
used the Text formula before but I always have to do a lot of trial and
error before I can get it to format the dates exactly the way I want it.

Your reply is perfect!quot;Kelly O'Dayquot; gt; wrote in message
...
gt; Wilfred:
gt;
gt; Here' a link to a post I have on dynamic titles that sounds like what you
gt; are looking for.
gt;
gt; processtrends.com/pg_chart_dy...hart_title.htm
gt;
gt; I use a text box and link the box to the chart by activating chart,
gt; entering quot;=quot; in formula bar then pointing to source cell.
gt;
gt; You can format the text and place where you want on the chart. As an
gt; aside, I prefer this text box approach to using Excel's chart title
gt; option. I find the chart title option takes up more space than is
gt; necessary for the title.
gt;
gt; As the source cell is updated, the title will automatically be updated.
gt;
gt; One last point, you can use a concatenation formula to make your source
gt; cell update as your week changes.
gt;
gt; Your source title could be = quot;Sales Activity for Week Ending quot; amp;
gt; Text(A1,quot;mmmm d, yyyyquot;). Substitute the actual date cell for A1 in this
gt; example.
gt;
gt;
gt; ..Kelly
gt;
gt;
gt;
gt;
gt;
gt; quot;Wilfredquot; gt; wrote in message
gt; . ..
gt;gt;I have a workbook with one data sheet and several charts which represent
gt;gt;weekly activity. I want to be able to pick up the title of the charts
gt;gt;from the spreadsheet, e.g. quot;Sales Activity for Week Ending April 7, 2006quot;.
gt;gt;This title information is contained in a cell in the spreadsheet.
gt;gt;
gt;gt; How do I get it to display at the top of each chart without having to
gt;gt; manually type it in the title area under Chart Options?
gt;gt;
gt;gt;
gt;gt;
gt;
gt;