Click here to Skip to main content
15,902,917 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionPackage and Deployment ? Pin
Member 7660843-Jan-04 21:51
Member 7660843-Jan-04 21:51 
AnswerRe: Package and Deployment ? Pin
elRaptor8-Jan-04 7:15
elRaptor8-Jan-04 7:15 
QuestionMenu -Help ? Pin
Member 7660843-Jan-04 21:49
Member 7660843-Jan-04 21:49 
AnswerRe: Menu -Help ? Pin
elRaptor8-Jan-04 7:38
elRaptor8-Jan-04 7:38 
GeneralHelp - Disable Ctrl - Esc Pin
Anonymous3-Jan-04 18:41
Anonymous3-Jan-04 18:41 
GeneralRe: Help - Disable Ctrl - Esc Pin
Dave Kreskowiak4-Jan-04 8:14
mveDave Kreskowiak4-Jan-04 8:14 
GeneralSending to a Web Form Pin
ProjectInsanity3-Jan-04 17:19
ProjectInsanity3-Jan-04 17:19 
GeneralBasic VB Excel Chart data selection Pin
mitreviper3-Jan-04 16:13
mitreviper3-Jan-04 16:13 
Hi all,

I need to draw a chart using VB with data from an excel sheet . How should the code be like if I want to have column A to be in the x-Axis and column B data to be the y axis. Please Help. Thanks

Below is my code that charts, but the data info is not what i want

oSheet3.Range("A1").Resize(51, 1).Value = ChartXDataArray
oSheet3.Range("B1").Resize(51, 1).Value = ChartYDataArray

Dim ch As Object
Dim chart1 As Object
Set ch = oSheet3.ChartObjects.Add(100, 30, 350, 270)
Set chart1 = ch.Chart
' chart1.Name = "NAme"

chart1.ChartType = xlColumnStacked
chart1.SetSourceData Source:=oSheet3.Range("B1:B51"), _
PlotBy:=xlColumns
chart1.SetSourceData Source:=oSheet3.Range("A1:A51"), _
PlotBy:=ylColumns
chart1.HasLegend = False


GeneralDatagrid "Edit Only" Pin
pchak3-Jan-04 8:12
pchak3-Jan-04 8:12 
GeneralRe: Datagrid "Edit Only" Pin
Guillermo Rivero3-Jan-04 17:24
Guillermo Rivero3-Jan-04 17:24 
GeneralHelp required Pin
emmshazi3-Jan-04 4:27
emmshazi3-Jan-04 4:27 
GeneralRe: Help required Pin
Guillermo Rivero3-Jan-04 17:31
Guillermo Rivero3-Jan-04 17:31 
GeneralRe: Help required Pin
Member 7660843-Jan-04 17:51
Member 7660843-Jan-04 17:51 
Generaltask scheduler Pin
Vipul Bhatt2-Jan-04 18:52
Vipul Bhatt2-Jan-04 18:52 
GeneralClickity Pin
Colin Angus Mackay3-Jan-04 2:46
Colin Angus Mackay3-Jan-04 2:46 
GeneralRe: task scheduler Pin
Colin Angus Mackay3-Jan-04 2:56
Colin Angus Mackay3-Jan-04 2:56 
GeneralParameter passing and reading [task scheduler] Pin
Vipul Bhatt2-Jan-04 18:48
Vipul Bhatt2-Jan-04 18:48 
GeneralClickity Pin
Colin Angus Mackay3-Jan-04 2:46
Colin Angus Mackay3-Jan-04 2:46 
GeneralRe: Parameter passing and reading [task scheduler] Pin
Colin Angus Mackay3-Jan-04 3:01
Colin Angus Mackay3-Jan-04 3:01 
GeneralRecursive File Copy/Delete Pin
crouchie042-Jan-04 13:23
crouchie042-Jan-04 13:23 
GeneralRe: Recursive File Copy/Delete Pin
BenBadger4-Jan-04 7:15
sussBenBadger4-Jan-04 7:15 
GeneralRe: Recursive File Copy/Delete Pin
Guillermo Rivero4-Jan-04 8:00
Guillermo Rivero4-Jan-04 8:00 
GeneralRe: Recursive File Copy/Delete Pin
Anonymous4-Jan-04 10:55
Anonymous4-Jan-04 10:55 
GeneralRe: Recursive File Copy/Delete Pin
Dave Kreskowiak5-Jan-04 4:02
mveDave Kreskowiak5-Jan-04 4:02 
GeneralComparing lists Pin
Member 7476772-Jan-04 8:22
Member 7476772-Jan-04 8:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.