Needed to plot multiple x&y graphs. X values is fixed.
Problems encountered: each y value have multiple values, thus i utilised the following equation as a subroutine function.
Sub lastRow()
lastRow=Cells(Rows.Count, 2).End(xlUp).Row
Range("B1:B"&lastRow).Select
When i run this 2 lines, there's an error.
Additionally, when i do that i realised that I have no idea how to loop it so that i can garner all the values for y-axis and is hard for me to plot a graph.
与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
