Thread: Auto x range start value, xy charts

I have several Excel xy charts plotting data that updates
automatically.

The x range varies from 0 to 40, 40 to 80, ... up to 560 to 600.

I want the chart x values to start at the lowest x value in the data,
but it actually starts at 0 for all values up to 160, then does what I
want for higher x starting values.

I have the x axis auto button selected.

Can anyone tell me how to stop the minimum value defaulting to zero?
Excel 2003 and Windows XP.

Hi,

Have a look at Tushar's Autochart addin.
http://tushar-mehta.com/excel/softwa...art/index.html

Cheers
Andy

dougaj4@hotmail.com wrote:
> I have several Excel xy charts plotting data that updates
> automatically.
>
> The x range varies from 0 to 40, 40 to 80, ... up to 560 to 600.
>
> I want the chart x values to start at the lowest x value in the data,
> but it actually starts at 0 for all values up to 160, then does what I
> want for higher x starting values.
>
> I have the x axis auto button selected.
>
> Can anyone tell me how to stop the minimum value defaulting to zero?
> Excel 2003 and Windows XP.
>

--

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

see if this idea helps

Sub setmin()
x = Application.Min(Range("d1:d12"))
Sheets("sheet4").ChartObjects("Chart 3"). _
Chart.Axes(xlValue).MinimumScale = x
End Sub

you may want to change x=
x=formulaarray."=MIN(IF(d1:d12>0,d1:d12))"

--
Don Guillett
SalesAid Software
donaldb@281.com
<dougaj4@hotmail.com> wrote in message
news:1106521612.205763.198760@z14g2000cwz.googlegroups.com...
> I have several Excel xy charts plotting data that updates
> automatically.
>
> The x range varies from 0 to 40, 40 to 80, ... up to 560 to 600.
>
> I want the chart x values to start at the lowest x value in the data,
> but it actually starts at 0 for all values up to 160, then does what I
> want for higher x starting values.
>
> I have the x axis auto button selected.
>
> Can anyone tell me how to stop the minimum value defaulting to zero?
> Excel 2003 and Windows XP.
>

better
x=SMALL(d1:d100,COUNTIF(d1:d100,0)+1)

--
Don Guillett
SalesAid Software
donaldb@281.com
"Don Guillett" <donaldb@281.com> wrote in message
news:OSYntUjAFHA.4044@TK2MSFTNGP10.phx.gbl...
> see if this idea helps
>
> Sub setmin()
> x = Application.Min(Range("d1:d12"))
> Sheets("sheet4").ChartObjects("Chart 3"). _
> Chart.Axes(xlValue).MinimumScale = x
> End Sub
>
> you may want to change x=
> x=formulaarray."=MIN(IF(d1:d12>0,d1:d12))"
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> <dougaj4@hotmail.com> wrote in message
> news:1106521612.205763.198760@z14g2000cwz.googlegroups.com...
> > I have several Excel xy charts plotting data that updates
> > automatically.
> >
> > The x range varies from 0 to 40, 40 to 80, ... up to 560 to 600.
> >
> > I want the chart x values to start at the lowest x value in the data,
> > but it actually starts at 0 for all values up to 160, then does what I
> > want for higher x starting values.
> >
> > I have the x axis auto button selected.
> >
> > Can anyone tell me how to stop the minimum value defaulting to zero?
> > Excel 2003 and Windows XP.
> >
>
>

Thanks Don & Andy

Thanks for that, the macro will do what I want.

A little surprising that this functionality isn't built in though!
Doug Jenkins

glad to help

--
Don Guillett
SalesAid Software
donaldb@281.com
<dougaj4@hotmail.com> wrote in message
news:1106603799.900881.313840@z14g2000cwz.googlegroups.com...
> Thanks Don & Andy
>
> Thanks for that, the macro will do what I want.
>
> A little surprising that this functionality isn't built in though!
> Doug Jenkins
>