Using a 'Name' to Update Chart Titles & "Y" Axis Scale

[Stilltrader47]

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?

 

[Andy Pope]

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/AxisScaleLinkToSheet.html

Cheers
Andy

 

[Stilltrader47]

Thanks Andy, I will check it out and advise

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/AxisScaleLinkToSheet.html

Cheers
Andy

--

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


.