Thanks Andy, I will check it out and advise
"Andy Pope" wrote:
Hi,
You can link chart title to a cell, although you will need to do each chart
individually.
http://www.andypope.info/tips/tip001.htm
as for the scale parameters that requires VBA code.
http://peltiertech.com/Excel/Charts/...nkToSheet.html
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Stilltrader47" wrote in message
...
My worksheet has 14 charts that each reference the same company name
(Title)
and "Y" axis scaling. Can I reference a 'Name' in:
Chart Options- Titles...
and
on scale- left click- format axis- scale...
The 'Name' for each variable would be a cell reference ie., G37
How do I update all 14 chart at once?
.