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

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?

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

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?

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

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?



.