problem

Maciej · Feb 11, 2004

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

John Walkenbach · Feb 11, 2004

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 · Feb 14, 2004

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 ??

Jon Peltier · Feb 16, 2004

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

Maciej · Feb 18, 2004

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 · Feb 19, 2004

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

Maciej · Feb 21, 2004

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

Maciej

Jon Peltier said:
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/
_______