Cell contents as Chart Title

S

Stephen Pain

Is there a way of using the contents of a cell on a worksheet as th
title for a chart on that same worksheet? Please bear in mind that I a
using Excel 97, although I would be interested to hear if it wa
possible in later versions of Excel as it may give me ammunition for a
upgrade!

Thanks,

Stev
 
A

Andy Pope

Hi,

You can link the chart title to a cell.
Select the chart title and then click in the formula bar. Enter and
equals and the click the required cell. Press <ENTER> to complete.

Cheers
Andy
 
Top