Optimize Chart Scale

frajaro · Apr 24th, 2002, 10:02 AM

Many times the automatic Scale option for Y-axis in charts doesn't fit to the optimal range of the values for a good appreciation of the fluctuation.
To avoid multiple manual Y-axis scale adjust, I run a macro but I wonder if there is a better solution.

Yor tip would be appreciated

[ This Message was edited by: frajaro on 2002-04-24 09:30 ]

Damon Ostrander · Apr 24th, 2002, 11:39 AM

Hi frajaro,

Since you apparently already have a macro that adjusts the axis scaling the way you want it, why not make the macro run automatically every time the chart re-calculates? You could use the Chart object Calculate event to do this. Just look up the topic "Chart Object Events" in the VBA helps. If your chart is embedded (rather than a chart sheet), you will need to also look at the topic "Using Events with Embedded Charts".

frajaro · Apr 24th, 2002, 11:56 AM

Thanks Damon,
really useful your advice,
regards,
Francisco

Apr 24th, 2002, 11:39 AM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi frajaro, Since you apparently already have a macro that adjusts the axis scaling the way you want it, why not make the macro run automatically every time the chart re-calculates? You could use the Chart object Calculate event to do this. Just look up the topic "Chart Object Events" in the VBA helps. If your chart is embedded (rather than a chart sheet), you will need to also look at the topic "Using Events with Embedded Charts". __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 10:02 AM	#1
frajaro New Member Join Date: Mar 2002 Posts: 13	Many times the automatic Scale option for Y-axis in charts doesn't fit to the optimal range of the values for a good appreciation of the fluctuation. To avoid multiple manual Y-axis scale adjust, I run a macro but I wonder if there is a better solution. Yor tip would be appreciated [ This Message was edited by: frajaro on 2002-04-24 09:30 ]

Apr 24th, 2002, 11:56 AM	#3
frajaro New Member Join Date: Mar 2002 Posts: 13	Thanks Damon, really useful your advice, regards, Francisco