Re: Naming a chart

Lynn,

You have to change the name of the chart in the properties window of the VBA
Select the chart from the project explorer and hit F4. Look for the (Name)
with brackets. If you change that you should be able to refer to your chart
in this fashion

MyCustomChart.AutoScaling = False

If you change the Name (without brackets) property you can refer to it like

Charts("MyCustomChart").AutoScaling = False

Hope that helps

Dan E

"Lynn" <tdunham@hydro.mb.ca> wrote in message
news:01cb01c3456f$daed5860$a301280a@phx.gbl...
> How do I name a chart so that it may be referred to in VBA
> code? The Help documentation indicates that this may be
> done by selecting the chart and typing in the Name box.
> This did not work for me however.

Can you see your sheets?

"Lynn" <tdunham@hydro.mb.ca> wrote in message
news:026f01c34575$95207b90$a301280a@phx.gbl...
> Thanks for the advice Dan but I couldn't find the Chart
> listed in the Project Explorer. Any ideas why I'm not
> seeing any of my charts listed?
>
> >-----Original Message-----
> >Lynn,
> >
> >You have to change the name of the chart in the
> properties window of the VBA
> >Select the chart from the project explorer and hit F4.
> Look for the (Name)
> >with brackets. If you change that you should be able to
> refer to your chart
> >in this fashion
> >
> >MyCustomChart.AutoScaling = False
> >
> >If you change the Name (without brackets) property you
> can refer to it like
> >
> >Charts("MyCustomChart").AutoScaling = False
> >
> >Hope that helps
> >
> >Dan E
> >
> >"Lynn" <tdunham@hydro.mb.ca> wrote in message
> >news:01cb01c3456f$daed5860$a301280a@phx.gbl...
> >> How do I name a chart so that it may be referred to in
> VBA
> >> code? The Help documentation indicates that this may be
> >> done by selecting the chart and typing in the Name box.
> >> This did not work for me however.
> >
> >
> >.
> >

Yes...I can see all of my sheets.
>-----Original Message-----
>Can you see your sheets?
>
>"Lynn" <tdunham@hydro.mb.ca> wrote in message
>news:026f01c34575$95207b90$a301280a@phx.gbl...
>> Thanks for the advice Dan but I couldn't find the Chart
>> listed in the Project Explorer. Any ideas why I'm not
>> seeing any of my charts listed?
>>
>> >-----Original Message-----
>> >Lynn,
>> >
>> >You have to change the name of the chart in the
>> properties window of the VBA
>> >Select the chart from the project explorer and hit F4.
>> Look for the (Name)
>> >with brackets. If you change that you should be able
to
>> refer to your chart
>> >in this fashion
>> >
>> >MyCustomChart.AutoScaling = False
>> >
>> >If you change the Name (without brackets) property you
>> can refer to it like
>> >
>> >Charts("MyCustomChart").AutoScaling = False
>> >
>> >Hope that helps
>> >
>> >Dan E
>> >
>> >"Lynn" <tdunham@hydro.mb.ca> wrote in message
>> >news:01cb01c3456f$daed5860$a301280a@phx.gbl...
>> >> How do I name a chart so that it may be referred to
in
>> VBA
>> >> code? The Help documentation indicates that this may
be
>> >> done by selecting the chart and typing in the Name
box.
>> >> This did not work for me however.
>> >
>> >
>> >.
>> >
>
>
>.
>

NFI???
No Clue

"Lynn" <tdunham@hydro.mb.ca> wrote in message
news:00cc01c3457b$4b8c0f70$a501280a@phx.gbl...
> Yes...I can see all of my sheets.
> >-----Original Message-----
> >Can you see your sheets?
> >
> >"Lynn" <tdunham@hydro.mb.ca> wrote in message
> >news:026f01c34575$95207b90$a301280a@phx.gbl...
> >> Thanks for the advice Dan but I couldn't find the Chart
> >> listed in the Project Explorer. Any ideas why I'm not
> >> seeing any of my charts listed?
> >>
> >> >-----Original Message-----
> >> >Lynn,
> >> >
> >> >You have to change the name of the chart in the
> >> properties window of the VBA
> >> >Select the chart from the project explorer and hit F4.
> >> Look for the (Name)
> >> >with brackets. If you change that you should be able
> to
> >> refer to your chart
> >> >in this fashion
> >> >
> >> >MyCustomChart.AutoScaling = False
> >> >
> >> >If you change the Name (without brackets) property you
> >> can refer to it like
> >> >
> >> >Charts("MyCustomChart").AutoScaling = False
> >> >
> >> >Hope that helps
> >> >
> >> >Dan E
> >> >
> >> >"Lynn" <tdunham@hydro.mb.ca> wrote in message
> >> >news:01cb01c3456f$daed5860$a301280a@phx.gbl...
> >> >> How do I name a chart so that it may be referred to
> in
> >> VBA
> >> >> code? The Help documentation indicates that this may
> be
> >> >> done by selecting the chart and typing in the Name
> box.
> >> >> This did not work for me however.
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >