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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Changing the "Chart Title", the "Category (X) axis" and the "Value (Y) axis"
via the change of a worksheet-cell would be useful. Does such a utility exist?
 
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.
 
Back
Top