Excel: Can I change Chart-title/category/value from a sheet-cell?

It is eay to make an example to do this. You just nee to select the chart
title and then input an formula such as "=Sheet1!A1" in the formulabar.

For the "Name of a Serie", it's working correctly, referring to "=Sheet1!A1".
But for "Chart-title", "Value X" and "Value Y", your reference to
"=Sheet1!A1" is not working. Chart-title will be then "=Sheet1!A1".

I hope a newer version of Excel will work in the way you describe.

Thanks in advance.


"AAA" wrote:

> It is eay to make an example to do this. You just nee to select the chart
> title and then input an formula such as "=Sheet1!A1" in the formulabar.
>
>
>

Hi,

AAA methods works in all versions since xl97 and possible before but I
can not check.
He is another explanation.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

femke wrote:
> For the "Name of a Serie", it's working correctly, referring to "=Sheet1!A1".
> But for "Chart-title", "Value X" and "Value Y", your reference to
> "=Sheet1!A1" is not working. Chart-title will be then "=Sheet1!A1".
>
> I hope a newer version of Excel will work in the way you describe.
>
> Thanks in advance.
>
>
> "AAA" wrote:
>
>
>>It is eay to make an example to do this. You just nee to select the chart
>>title and then input an formula such as "=Sheet1!A1" in the formulabar.
>>
>>
>>

--

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

Andy,

Thank you for your info. It's working now!

"Andy Pope" wrote:

> Hi,
>
> AAA methods works in all versions since xl97 and possible before but I
> can not check.
> He is another explanation.
> http://www.andypope.info/tips/tip001.htm
>
> Cheers
> Andy
>
> femke wrote:
> > For the "Name of a Serie", it's working correctly, referring to "=Sheet1!A1".
> > But for "Chart-title", "Value X" and "Value Y", your reference to
> > "=Sheet1!A1" is not working. Chart-title will be then "=Sheet1!A1".
> >
> > I hope a newer version of Excel will work in the way you describe.
> >
> > Thanks in advance.
> >
> >
> > "AAA" wrote:
> >
> >
> >>It is eay to make an example to do this. You just nee to select the chart
> >>title and then input an formula such as "=Sheet1!A1" in the formulabar.
> >>
> >>
> >>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>