VBA Automatic Plotting Help

[junglekingmowgli]

Hi Everyone,

I am fairly new to VBA coding, and I needed some simple help. For my x-axis, I want to select time. For my Y-axis, I want to select temperature. This data is already provided to me.

I want to plot the data using scatter of line graph options. The problem arises because the data sets do not have equal number of rows. For example, 1 data set will have 200 rows and another 300. Thus, I need a VBA code that will select the data (last row) automatically and plot it.

All your help would be greatly appreciated.

Thank you!

 

[mole999]

if your using 2003 you can create a macro that records your actions to get the chart as you want it, then, the code can be tweaked to extend the range

 

[junglekingmowgli]

I should have been more clear. I am running 2007. I tried to record it, but it only selects the same data range every time. I need help in writing the commant to automatically select the last data row.

Thanks!

 

[mole999]

This is useable, and configurable

Sub LastRowInOneColumn()
'Find the last used row in a Column: column A in this example
    Dim LastRow As Long
    With ActiveSheet
        LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
    End With
    MsgBox LastRow
End Sub

 

[roc_on_the_rocks]

This should help you:

http://www.mrexcel.com/forum/showthread.php?t=518664
​

Credits to alx700.