Thread: Autoscaling on XY chart

Hi,

Is VBA the only solution to autoscale axis in an XY plot...? I would like to
set the min and max for my x-axis as my data changes. (I know how to do it
through VBA).

Or is there any other short-cut?


--
- Mangesh
------------------------------------------
Office 2003 & Windows XP

Hi,

Unfortunately you can not link the min/max of the scale to cells
directly. I think VBA is the only approach to dynamic updating of those
properties.

Cheers
Andy

Mangesh Yadav wrote:
> Hi,
>
> Is VBA the only solution to autoscale axis in an XY plot...? I would like to
> set the min and max for my x-axis as my data changes. (I know how to do it
> through VBA).
>
> Or is there any other short-cut?
>
>
> --
> - Mangesh
> ------------------------------------------
> Office 2003 & Windows XP
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Yes, thats true. But I remember vaguely that Tushar Mehta had suggested some
method quite some days back. I may be wrong, it could be for some other
chart type (and not XY).

Mangesh


"Andy Pope" <andy@andypope.info> wrote in message
news:uSNng#XnFHA.1092@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Unfortunately you can not link the min/max of the scale to cells
> directly. I think VBA is the only approach to dynamic updating of those
> properties.
>
> Cheers
> Andy
>
> Mangesh Yadav wrote:
> > Hi,
> >
> > Is VBA the only solution to autoscale axis in an XY plot...? I would
like to
> > set the min and max for my x-axis as my data changes. (I know how to do
it
> > through VBA).
> >
> > Or is there any other short-cut?
> >
> >
> > --
> > - Mangesh
> > ------------------------------------------
> > Office 2003 & Windows XP
> >
> >
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info

The only option that comes to mind is an add-in that works 'behind the
scenes.' See
AutoChart Manager
http://www.tushar-mehta.com/excel/so...art/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <OEwaTZYnFHA.1412@TK2MSFTNGP09.phx.gbl>,
mangesh.NOSPAMyadav@gmail.com says...
> Yes, thats true. But I remember vaguely that Tushar Mehta had suggested some
> method quite some days back. I may be wrong, it could be for some other
> chart type (and not XY).
>
> Mangesh
>
>
> "Andy Pope" <andy@andypope.info> wrote in message
> news:uSNng#XnFHA.1092@TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > Unfortunately you can not link the min/max of the scale to cells
> > directly. I think VBA is the only approach to dynamic updating of those
> > properties.
> >
> > Cheers
> > Andy
> >
> > Mangesh Yadav wrote:
> > > Hi,
> > >
> > > Is VBA the only solution to autoscale axis in an XY plot...? I would
> like to
> > > set the min and max for my x-axis as my data changes. (I know how to do
> it
> > > through VBA).
> > >
> > > Or is there any other short-cut?
> > >
> > >
> > > --
> > > - Mangesh
> > > ------------------------------------------
> > > Office 2003 & Windows XP
> > >
> > >
> >
> > --
> >
> > Andy Pope, Microsoft MVP - Excel
> > http://www.andypope.info
>
>
>

Hi Tushar,

Thanks for the response. I have already checked the addin on your link, and
I don't want to go that way.
I think what I was refering to was probably some other chart type. Anyway,
if I ever find it tou, will let you know.

Mangesh



"Tushar Mehta" <tmUnderscore200310@tushar-mehta.SeeOhEm> wrote in message
news:MPG.1d63ac9f301375ab98b0f4@msnews.microsoft.com...
> The only option that comes to mind is an add-in that works 'behind the
> scenes.' See
> AutoChart Manager
> http://www.tushar-mehta.com/excel/so...art/index.html
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <OEwaTZYnFHA.1412@TK2MSFTNGP09.phx.gbl>,
> mangesh.NOSPAMyadav@gmail.com says...
> > Yes, thats true. But I remember vaguely that Tushar Mehta had suggested
some
> > method quite some days back. I may be wrong, it could be for some other
> > chart type (and not XY).
> >
> > Mangesh
> >
> >
> > "Andy Pope" <andy@andypope.info> wrote in message
> > news:uSNng#XnFHA.1092@TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > >
> > > Unfortunately you can not link the min/max of the scale to cells
> > > directly. I think VBA is the only approach to dynamic updating of
those
> > > properties.
> > >
> > > Cheers
> > > Andy
> > >
> > > Mangesh Yadav wrote:
> > > > Hi,
> > > >
> > > > Is VBA the only solution to autoscale axis in an XY plot...? I would
> > like to
> > > > set the min and max for my x-axis as my data changes. (I know how to
do
> > it
> > > > through VBA).
> > > >
> > > > Or is there any other short-cut?
> > > >
> > > >
> > > > --
> > > > - Mangesh
> > > > ------------------------------------------
> > > > Office 2003 & Windows XP
> > > >
> > > >
> > >
> > > --
> > >
> > > Andy Pope, Microsoft MVP - Excel
> > > http://www.andypope.info
> >
> >
> >

On Wed, 10 Aug 2005 17:10:05 +0530, "Mangesh Yadav"
<mangesh.NOSPAMyadav@gmail.com> wrote:

>Hi Tushar,
>
>Thanks for the response. I have already checked the addin on your link, and
>I don't want to go that way.
>I think what I was refering to was probably some other chart type. Anyway,
>if I ever find it tou, will let you know.
>
>Mangesh
>


The only other way I can think of is to create a "fake" data set that
only contains the data that fall within your boundaries and then let
the chart auto-scale options sort it out.

i.e. if you want the "x-axis" to be from 5 to 10 then you'd filter out
any data points where the x value was outside this range.

Hi Paolo,

Thanks for the response. Anyway, at the moment I am going ahead with the VBA
solution.

Mangesh


"Paolo" <p@d.co> wrote in message
news:vhbkf1l7uvo5rbshr8bfmj1bt86meupiae@4ax.com...
> On Wed, 10 Aug 2005 17:10:05 +0530, "Mangesh Yadav"
> <mangesh.NOSPAMyadav@gmail.com> wrote:
>
> >Hi Tushar,
> >
> >Thanks for the response. I have already checked the addin on your link,
and
> >I don't want to go that way.
> >I think what I was refering to was probably some other chart type.
Anyway,
> >if I ever find it tou, will let you know.
> >
> >Mangesh
> >
>
>
> The only other way I can think of is to create a "fake" data set that
> only contains the data that fall within your boundaries and then let
> the chart auto-scale options sort it out.
>
> i.e. if you want the "x-axis" to be from 5 to 10 then you'd filter out
> any data points where the x value was outside this range.
>
>
>