 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / February 2004problem
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 > Hello > I'm reading data from text file into excel sheet using VBA. I am [quoted text clipped - 3 lines] > > 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 ?? > That command works on the active sheet. Are you sure the active sheet is > what you think it is? [quoted text clipped - 10 lines] > > > > 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/ _______ > hello John > yes i think so - the problem is: when columns with data series are [quoted text clipped - 17 lines] >>> >>>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 > 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 [quoted text clipped - 28 lines] > >>> > >>>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/ _______ > hi > ok it works manually but I have to generate this file automatically [quoted text clipped - 34 lines] >>>>> >>>>>Maciej Thx jon - that's what I want :-) Maciej > Macie - > [quoted text clipped - 52 lines] > >>>>> > >>>>>Maciej |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.