| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating Multiple Chart Titles and Scaling to Identical Values
Thanks Jarek, I will check it out and advise
"Jarek Kujawa" wrote: try use this macro (with yr maximum for Y axis in G1 and name in G37). to insert the macro press ALT+F11 to go to VBA and paste the code that follows Sub cus() For Each cho In ActiveSheet.ChartObjects cho.Activate With ActiveChart .HasTitle = True .ChartTitle.Characters.Text = Range("G37") .Axes(xlValue).MaximumScale = Range("G1") End With Next End Sub pls click YES if it helped On 26 Lis, 07:03, Stilltrader47 wrote: 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? . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Multiple Chart Titles | Charts and Charting in Excel | |||
| Automatically updating chart titles | Charts and Charting in Excel | |||
| How do I hide zero values (and their titles) in a pie chart in exc | Charts and Charting in Excel | |||
| Scaling within a chart | Charts and Charting in Excel | |||
| Looking Up Datas when Key Values are Identical | Excel Worksheet Functions | |||
Threaded Mode
