how to use a cell contents as a graph title

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carl - 21 May 2008 11:38 GMT

I want to be able to use the contents of a cell to set the title of a chart.
Changing the cell contents would then automatically change the title of the
chart.

Reply to this Message

Andy Pope - 21 May 2008 11:58 GMT

Hi,

You can find details here
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

>I want to be able to use the contents of a cell to set the title of a
>chart.
> Changing the cell contents would then automatically change the title of
> the
> chart.

Reply to this Message

Carl - 21 May 2008 12:32 GMT

Thank you Andy. Top tip!!

> Hi,
>
[quoted text clipped - 9 lines]
> > the
> > chart.

Reply to this Message

John McCabe - 21 May 2008 13:22 GMT

Check this newsgroup back on Jan. 8, 2008.. I have done it but could never
try to explain it.

>I want to be able to use the contents of a cell to set the title of a
>chart.
> Changing the cell contents would then automatically change the title of
> the
> chart.

Reply to this Message