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?
|