$$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$$ Re: Excel Chart Macro to Set Axis Values

2009-10-23 Thread Hemant K
Hi friends, Can any body help me in this i want to insert rows between alternate rows for example Row No. sr. no. name 10 1 sachin 11 2 piyush 12 3 amit 13 4 pankaj 14 5 hitendra I want it to be Row No. sr. no. name 10 1 sachin 11 12 2 piyush 13 14 3 ami

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

2009-10-23 Thread danielc
Hello. Select axis, Format axis, set minimum to 1/1/10 and maximum to 4/30/10. HTH Daniel On 22 oct, 20:03, Wataridori wrote: > 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, wi