software

In cell F2 of a sheet named quot;main flashquot; I want to have it display the
following:

quot;for week 42 endingquot;

The week 42 part would come from another sheet named quot;actualsquot; that's
in the same workbook.--
Weasel
------------------------------------------------------------------------
Weasel's Profile: www.excelforum.com/member.php...oamp;userid=27206
View this thread: www.excelforum.com/showthread...hreadid=525683Hi

You could do something like this:
=quot;for week quot;amp;E2amp;quot; endingquot;

Andy.

quot;Weaselquot; gt; wrote in
message ...
gt;
gt; In cell F2 of a sheet named quot;main flashquot; I want to have it display the
gt; following:
gt;
gt; quot;for week 42 endingquot;
gt;
gt; The week 42 part would come from another sheet named quot;actualsquot; that's
gt; in the same workbook.
gt;
gt;
gt; --
gt; Weasel
gt; ------------------------------------------------------------------------
gt; Weasel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=27206
gt; View this thread: www.excelforum.com/showthread...hreadid=525683
gt;
=quot;for week quot; amp; actuals!x99 amp; quot; endingquot;

You could even do:

=quot;Please pay me by: quot; amp; text(a1,quot;mm/dd/yyyyquot;)

to get the formatting the way you want.

Weasel wrote:
gt;
gt; In cell F2 of a sheet named quot;main flashquot; I want to have it display the
gt; following:
gt;
gt; quot;for week 42 endingquot;
gt;
gt; The week 42 part would come from another sheet named quot;actualsquot; that's
gt; in the same workbook.
gt;
gt; --
gt; Weasel
gt; ------------------------------------------------------------------------
gt; Weasel's Profile: www.excelforum.com/member.php...oamp;userid=27206
gt; View this thread: www.excelforum.com/showthread...hreadid=525683

--

Dave Peterson


would the same formula/method apply for making a chart haeading label
responsive?

My chart is driven by the vaue of A1 which is defined by a combo box. I
would like the chart heading to look something like

= quot;estimated VAT Forquot; amp; A1--
cereldine
------------------------------------------------------------------------
cereldine's Profile: www.excelforum.com/member.php...oamp;userid=32069
View this thread: www.excelforum.com/showthread...hreadid=525683Hi

I don't think so. Have a look here for a pretty exhaustive site on charts:
www.contextures.com/JPChartIndex.htm

Andy.

quot;cereldinequot; gt; wrote
in message ...
gt;
gt; would the same formula/method apply for making a chart haeading label
gt; responsive?
gt;
gt; My chart is driven by the vaue of A1 which is defined by a combo box. I
gt; would like the chart heading to look something like
gt;
gt; = quot;estimated VAT Forquot; amp; A1
gt;
gt;
gt; --
gt; cereldine
gt; ------------------------------------------------------------------------
gt; cereldine's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32069
gt; View this thread: www.excelforum.com/showthread...hreadid=525683
gt;
cereldine wrote

gt;
gt; would the same formula/method apply for making a chart haeading label
gt; responsive?
gt;
gt; My chart is driven by the vaue of A1 which is defined by a combo box. I
gt; would like the chart heading to look something like
gt;
gt; = quot;estimated VAT Forquot; amp; A1
gt;
gt;

The way I accomplished this was to tuck the source for the chart title away
in a cell (say B30) in a hidden row (30) and then refer the chart title box
to that:
B30 =quot;estimated VAT Forquot; amp; A1
Chart Title reference: =Sheet1!B30 lt;--Sheetname needed for some reason.
Once you place your formula in the cell you will eventually hide (for
cosmetic reasons), you can click the Chart Title box, type =, and click the
cell with the formula and the sheet name will automatically be added.
Hope I haven't confused you too much.

--
David


Thanks David, works a treat for anyone else looking to have more
informative charts--
cereldine
------------------------------------------------------------------------
cereldine's Profile: www.excelforum.com/member.php...oamp;userid=32069
View this thread: www.excelforum.com/showthread...hreadid=525683