Basic VB Excel Chart data selection
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
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