How do I change a Chart's axis scale from visual basic?

How do I change a Chart's (that is on a worksheet) x-axis scale from visual
basic?

The following only works when the chart has its own sheet/tab.
With Charts("Chart1").Axes(xlCategory)
.MinimumScale = 740.25
.MaximumScale = 746.25
End With

If it is located within a worksheet how do you reference it?

Hi,

Some more like this for chartobject,

With ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlCategory)
.MinimumScale = 740.25
.MaximumScale = 746.25
End With

Cheers
Andy

jfiorillo wrote:
> How do I change a Chart's (that is on a worksheet) x-axis scale from visual
> basic?
>
> The following only works when the chart has its own sheet/tab.
> With Charts("Chart1").Axes(xlCategory)
> .MinimumScale = 740.25
> .MaximumScale = 746.25
> End With
>
> If it is located within a worksheet how do you reference it?

--

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

Thanks a bunch.
Excellent.
John

"Andy Pope" wrote:

> Hi,
>
> Some more like this for chartobject,
>
> With ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlCategory)
> .MinimumScale = 740.25
> .MaximumScale = 746.25
> End With
>
> Cheers
> Andy
>
> jfiorillo wrote:
> > How do I change a Chart's (that is on a worksheet) x-axis scale from visual
> > basic?
> >
> > The following only works when the chart has its own sheet/tab.
> > With Charts("Chart1").Axes(xlCategory)
> > .MinimumScale = 740.25
> > .MaximumScale = 746.25
> > End With
> >
> > If it is located within a worksheet how do you reference it?
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>