problem

Hello
I'm reading data from text file into excel sheet using VBA. I am
creating (using VBA) chart on 2 imported columns. I want to hide this
columns (Columns("AA").Hidden = True) but it doesn't work - how to
solve this problem using only VBA macro in Excel ?? Pleas help me.

Maciej

That command works on the active sheet. Are you sure the active sheet is
what you think it is?

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss


"Maciej" <maciej_ty@poczta.onet.pl> wrote in message
news:1eb7cfcc.0402101633.105ce926@posting.google.com...
> Hello
> I'm reading data from text file into excel sheet using VBA. I am
> creating (using VBA) chart on 2 imported columns. I want to hide this
> columns (Columns("AA").Hidden = True) but it doesn't work - how to
> solve this problem using only VBA macro in Excel ?? Pleas help me.
>
> Maciej

hello John
yes i think so - the problem is: when columns with data series are
visible (i set width = 1 - but they are still visible :-() my chart
looks fine, when I hide this columns (.Hidden = True) my chart looks
like if lost data :-(.
anybody know what to do ??


"John Walkenbach" <john@j-walk.com> wrote in message news:<utSgdCE8DHA.1948@TK2MSFTNGP12.phx.gbl>...
> That command works on the active sheet. Are you sure the active sheet is
> what you think it is?
>
> John Walkenbach
> For Excel tips, macros, & downloads...
> http://j-walk.com/ss
>
>
> "Maciej" <maciej_ty@poczta.onet.pl> wrote in message
> news:1eb7cfcc.0402101633.105ce926@posting.google.com...
> > Hello
> > I'm reading data from text file into excel sheet using VBA. I am
> > creating (using VBA) chart on 2 imported columns. I want to hide this
> > columns (Columns("AA").Hidden = True) but it doesn't work - how to
> > solve this problem using only VBA macro in Excel ?? Pleas help me.
> >
> > Maciej

By default, a chart does not show hidden data. To change this, select
the chart, then go to the Options command on the Tools menu. On the
Chart tab, uncheck the Plot Visible Cells Only box.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Maciej wrote:

> hello John
> yes i think so - the problem is: when columns with data series are
> visible (i set width = 1 - but they are still visible :-() my chart
> looks fine, when I hide this columns (.Hidden = True) my chart looks
> like if lost data :-(.
> anybody know what to do ??
>
>
> "John Walkenbach" <john@j-walk.com> wrote in message news:<utSgdCE8DHA.1948@TK2MSFTNGP12.phx.gbl>...
>
>>That command works on the active sheet. Are you sure the active sheet is
>>what you think it is?
>>
>>John Walkenbach
>>For Excel tips, macros, & downloads...
>>http://j-walk.com/ss
>>
>>
>>"Maciej" <maciej_ty@poczta.onet.pl> wrote in message
>>news:1eb7cfcc.0402101633.105ce926@posting.google.com...
>>
>>>Hello
>>>I'm reading data from text file into excel sheet using VBA. I am
>>>creating (using VBA) chart on 2 imported columns. I want to hide this
>>>columns (Columns("AA").Hidden = True) but it doesn't work - how to
>>>solve this problem using only VBA macro in Excel ?? Pleas help me.
>>>
>>>Maciej

hi
ok it works manually but I have to generate this file automatically
using VBA macro so how can i set this chart option from VBA code level
??
Maciej


Jon Peltier <jonxlmvpNO@SPAMpeltiertech.com> wrote in message news:<OubCO9I9DHA.488@TK2MSFTNGP12.phx.gbl>...
> By default, a chart does not show hidden data. To change this, select
> the chart, then go to the Options command on the Tools menu. On the
> Chart tab, uncheck the Plot Visible Cells Only box.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> http://PeltierTech.com/Excel/Charts/
> _______
>
> Maciej wrote:
>
> > hello John
> > yes i think so - the problem is: when columns with data series are
> > visible (i set width = 1 - but they are still visible :-() my chart
> > looks fine, when I hide this columns (.Hidden = True) my chart looks
> > like if lost data :-(.
> > anybody know what to do ??
> >
> >
> > "John Walkenbach" <john@j-walk.com> wrote in message news:<utSgdCE8DHA.1948@TK2MSFTNGP12.phx.gbl>...
> >
> >>That command works on the active sheet. Are you sure the active sheet is
> >>what you think it is?
> >>
> >>John Walkenbach
> >>For Excel tips, macros, & downloads...
> >>http://j-walk.com/ss
> >>
> >>
> >>"Maciej" <maciej_ty@poczta.onet.pl> wrote in message
> >>news:1eb7cfcc.0402101633.105ce926@posting.google.com...
> >>
> >>>Hello
> >>>I'm reading data from text file into excel sheet using VBA. I am
> >>>creating (using VBA) chart on 2 imported columns. I want to hide this
> >>>columns (Columns("AA").Hidden = True) but it doesn't work - how to
> >>>solve this problem using only VBA macro in Excel ?? Pleas help me.
> >>>
> >>>Maciej

Macie -

I turned on the macro recorder, then did it manually. The recorder gave
me this (plus some other lines not relevant to this option):

With ActiveChart
.PlotVisibleOnly = False
End With

The recorder's good for little hints like this.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Maciej wrote:

> hi
> ok it works manually but I have to generate this file automatically
> using VBA macro so how can i set this chart option from VBA code level
> ??
> Maciej
>
>
> Jon Peltier <jonxlmvpNO@SPAMpeltiertech.com> wrote in message news:<OubCO9I9DHA.488@TK2MSFTNGP12.phx.gbl>...
>
>>By default, a chart does not show hidden data. To change this, select
>>the chart, then go to the Options command on the Tools menu. On the
>>Chart tab, uncheck the Plot Visible Cells Only box.
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>http://PeltierTech.com/Excel/Charts/
>>_______
>>
>>Maciej wrote:
>>
>>
>>>hello John
>>>yes i think so - the problem is: when columns with data series are
>>>visible (i set width = 1 - but they are still visible :-() my chart
>>>looks fine, when I hide this columns (.Hidden = True) my chart looks
>>>like if lost data :-(.
>>>anybody know what to do ??
>>>
>>>
>>>"John Walkenbach" <john@j-walk.com> wrote in message news:<utSgdCE8DHA.1948@TK2MSFTNGP12.phx.gbl>...
>>>
>>>
>>>>That command works on the active sheet. Are you sure the active sheet is
>>>>what you think it is?
>>>>
>>>>John Walkenbach
>>>>For Excel tips, macros, & downloads...
>>>>http://j-walk.com/ss
>>>>
>>>>
>>>>"Maciej" <maciej_ty@poczta.onet.pl> wrote in message
>>>>news:1eb7cfcc.0402101633.105ce926@posting.google.com...
>>>>
>>>>
>>>>>Hello
>>>>>I'm reading data from text file into excel sheet using VBA. I am
>>>>>creating (using VBA) chart on 2 imported columns. I want to hide this
>>>>>columns (Columns("AA").Hidden = True) but it doesn't work - how to
>>>>>solve this problem using only VBA macro in Excel ?? Pleas help me.
>>>>>
>>>>>Maciej

Thx jon - that's what I want :-)
Maciej


Jon Peltier <jonxlmvpNO@SPAMpeltiertech.com> wrote in message news:<ueAza2v9DHA.2028@TK2MSFTNGP10.phx.gbl>...
> Macie -
>
> I turned on the macro recorder, then did it manually. The recorder gave
> me this (plus some other lines not relevant to this option):
>
> With ActiveChart
> .PlotVisibleOnly = False
> End With
>
> The recorder's good for little hints like this.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> http://PeltierTech.com/Excel/Charts/
> _______
>
> Maciej wrote:
>
> > hi
> > ok it works manually but I have to generate this file automatically
> > using VBA macro so how can i set this chart option from VBA code level
> > ??
> > Maciej
> >
> >
> > Jon Peltier <jonxlmvpNO@SPAMpeltiertech.com> wrote in message news:<OubCO9I9DHA.488@TK2MSFTNGP12.phx.gbl>...
> >
> >>By default, a chart does not show hidden data. To change this, select
> >>the chart, then go to the Options command on the Tools menu. On the
> >>Chart tab, uncheck the Plot Visible Cells Only box.
> >>
> >>- Jon
> >>-------
> >>Jon Peltier, Microsoft Excel MVP
> >>Peltier Technical Services
> >>http://PeltierTech.com/Excel/Charts/
> >>_______
> >>
> >>Maciej wrote:
> >>
> >>
> >>>hello John
> >>>yes i think so - the problem is: when columns with data series are
> >>>visible (i set width = 1 - but they are still visible :-() my chart
> >>>looks fine, when I hide this columns (.Hidden = True) my chart looks
> >>>like if lost data :-(.
> >>>anybody know what to do ??
> >>>
> >>>
> >>>"John Walkenbach" <john@j-walk.com> wrote in message news:<utSgdCE8DHA.1948@TK2MSFTNGP12.phx.gbl>...
> >>>
> >>>
> >>>>That command works on the active sheet. Are you sure the active sheet is
> >>>>what you think it is?
> >>>>
> >>>>John Walkenbach
> >>>>For Excel tips, macros, & downloads...
> >>>>http://j-walk.com/ss
> >>>>
> >>>>
> >>>>"Maciej" <maciej_ty@poczta.onet.pl> wrote in message
> >>>>news:1eb7cfcc.0402101633.105ce926@posting.google.com...
> >>>>
> >>>>
> >>>>>Hello
> >>>>>I'm reading data from text file into excel sheet using VBA. I am
> >>>>>creating (using VBA) chart on 2 imported columns. I want to hide this
> >>>>>columns (Columns("AA").Hidden = True) but it doesn't work - how to
> >>>>>solve this problem using only VBA macro in Excel ?? Pleas help me.
> >>>>>
> >>>>>Maciej