C
cereldine
Hi,
I have created a worksheet that is a summary of underlying data an
contains many charts. This sheet is dynamic and driven by a combo bo
to select which sector to display, the combo value is posted in cel
A1
Within the chart heading labels i would like it to give a brief tex
and then the value of cell A1 e.g.
Estimated Costs: Construction
In this case cell A1 containing the text construction. Is there an eas
to use formula for this or will it involve VBA? I would like to avoi
VBA if possible, Thank
I have created a worksheet that is a summary of underlying data an
contains many charts. This sheet is dynamic and driven by a combo bo
to select which sector to display, the combo value is posted in cel
A1
Within the chart heading labels i would like it to give a brief tex
and then the value of cell A1 e.g.
Estimated Costs: Construction
In this case cell A1 containing the text construction. Is there an eas
to use formula for this or will it involve VBA? I would like to avoi
VBA if possible, Thank