Dynamic Chart title

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

navin - 04 Jan 2007 20:57 GMT

Hi,

I want my chart title to display the value entered in a cell.
A2="Date". I did a right click on the chart options and entered =A2 in
the chart title box. However, on clicking "OK", the chart title
displays the "=A2" instead of the value enterd in cell A2.

Thanks in advance.

regards,
Navin

Reply to this Message

Dave Peterson - 04 Jan 2007 21:12 GMT

What do you see in A2?

If you see the formula, format that cell as General and reenter the formula.

> Hi,
>
[quoted text clipped - 7 lines]
> regards,
> Navin

Signature

Dave Peterson

Reply to this Message

Andy Pope - 04 Jan 2007 21:36 GMT

Hi,

This should help.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

> Hi,
>
[quoted text clipped - 7 lines]
> regards,
> Navin

Reply to this Message

Rate this thread: