Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
10-23-2008, 12:03 AM #1
- Join Date
- Oct 2008
- Thanked 0 Times in 0 Posts
problem with Reading and plotting data in VBA - excel application
I have a excel sheet of 5 columns, each with 5 rows. First,I read some selected columns from the sheet. then perform an arithmetic operation on all elements of the selected columns. then draw a chart with the modified columns.
My code is as follows(please see the comments to know what i am doing)
Dim y(1 To 5) As String 'declaring a string array y(1) = "=sheet1!R1C1:R5C1" 'Reading columns y(2) = "=sheet1!R1C2:R5C2" y(3) = "=sheet1!R1C3:R5C3" y(4) = "=sheet1!R1C4:R5C4" y(5) = "=sheet1!R1C5:R5C5" dim NewY(1 to 5) as double For i = 1 To 5 NewY(i) = Sheets("sheet1").Cells(i , 3) + 2.02 'Adding 2.02 to all elements of column3 Next i Charts.Add ActiveChart.ChartArea.Clear ActiveChart.ChartType = xlXYScatterSmoothNoMarkers ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues =y(1) ' X-axis is column1 ActiveChart.SeriesCollection(1).Values = xxxxxxxx
Can any one help me, What should I write here in place of xxxxxxxx to make a plot between Column 1 of my sheet to the modified values of column 3?
thanks in advance!