software

Hi,
I have created a worksheet that is a summary of underlying data and
contains many charts. This sheet is dynamic and driven by a combo box
to select which sector to display, the combo value is posted in cell
A1

Within the chart heading labels i would like it to give a brief text
and then the value of cell A1 e.g.

Estimated Costs: Construction

In this case cell A1 containing the text construction. Is there an easy
to use formula for this or will it involve VBA? I would like to avoid
VBA if possible, Thanks--
cereldine
------------------------------------------------------------------------
cereldine's Profile: www.excelforum.com/member.php...oamp;userid=32069
View this thread: www.excelforum.com/showthread...hreadid=525694