$$Excel-Macros$$ Re: Excel Chart Macro to Set Axis Values

2009-10-26 Thread Wataridori
Hi, Anyone have an idea how to use the maximumscale and minimumscale objects in VBA to refer to the maximum range of data on an axis? Thanks. --~--~-~--~~~---~--~~ -- Some important l

$$Excel-Macros$$ Re: Excel Chart Macro to Set Axis Values

2009-10-23 Thread Wataridori
Hi, I guess I should have specified that I was asking for a way to do the setting of the axis values by VBA, automatically for different files, instead of manually setting the maximum and minimum values. Thanks! --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Excel Chart Macro to Set Axis Values

2009-10-22 Thread Wataridori
Hi all, I was wondering if there is a way to set the axis values of a scatter chart to the maximum and minimum values given in the source data. For example, with the following data: Date Val 1/1/1010 2/20/10 15 3/15/106 4/31/10 19 I want the X axis range to be between 1/1/10 an