Hi
I'm creating a regular trend graph from the values in an excel file for contiguous columns as follows:
    Charts.Add
    ActiveChart.ChartType = xlLineMarkers
    ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range(Sheets("Sheet1").Ce lls(7, 1), Sheets("Sheet1").Cells(Sheets("Sheet1").UsedRange. Rows.Count, Sheets("Sheet1").UsedRange.Columns.Count)), PlotBy:= _
        xlRows

Can anyone please help me in plotting the graph where the values should be taken of only columns 1, 4, 7, etc. and all columns will have the same number of rows. Please tell me how should i modify the code accordingly
Thanks a lot in advance

Hi

The easiest way to do these things is to use the "Record Macro" Feature in excel. Press record, create the graph the way you would want it and then access the module from your Excel VB Editor. Copy the code to your VB6 project...

Hope this helps...lemme know if you need more info.

Regards
Marnus