Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ChartWizard | Charts and Charting in Excel | |||
chart.ChartWizard always failed in excel2k7 | Charts and Charting in Excel | |||
range from worksheet ala chartwizard | Charts and Charting in Excel | |||
I am having a problem opening up an attachment in Outlook Express. | Excel Discussion (Misc queries) |