Problem changing chartype using Chartwizard in VB Express
Hi,
I am trying to create a line graph using a Microsoft VB Express module. I can get the grpah to appear with labels etc however I cannot change the chart type to line(or any other type). Below is the segment of code I have to display the graph: With oBook.ActiveSheet.ChartObjects.Add _ (Left:=100, Width:=375, Top:=75, Height:=225) .Chart.ChartWizard(Source:=oBook.ActiveSheet.Range ("C4:C10"), Gallery:=xlLine, Title:="TEST", _ ValueTitle:="# of trans", CategoryTitle:="tps") End With The error I get is " Name 'xlLine' is not declared. What I dont understand is that the Title,ValueTitle,CategoryTitle properties all work fine but I get the error on the Gallery property. Any suggestions appreciated. -- KT |
Problem changing chartype using Chartwizard in VB Express
What's VB Express? Is that the lightweight dot-net thingy Microsoft released
a couple years ago? xlLine is a built-in Excel VBA constant. If you have set a reference to Excel's object library, this would probably not be an issue. Whatever. Go to Excel's VB Editor. Press Ctrl+G to open the Immediate Window. In the Immediate Window, type ?xlLine and press Enter. VBA responds with 4. Replace the xlLine constant with the value 4, and your code should run. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Kenny Thompson" wrote in message ... Hi, I am trying to create a line graph using a Microsoft VB Express module. I can get the grpah to appear with labels etc however I cannot change the chart type to line(or any other type). Below is the segment of code I have to display the graph: With oBook.ActiveSheet.ChartObjects.Add _ (Left:=100, Width:=375, Top:=75, Height:=225) .Chart.ChartWizard(Source:=oBook.ActiveSheet.Range ("C4:C10"), Gallery:=xlLine, Title:="TEST", _ ValueTitle:="# of trans", CategoryTitle:="tps") End With The error I get is " Name 'xlLine' is not declared. What I dont understand is that the Title,ValueTitle,CategoryTitle properties all work fine but I get the error on the Gallery property. Any suggestions appreciated. -- KT |
All times are GMT +1. The time now is 03:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com