I currently have the following code with a table from Range("Y2:AB" & iRow3), where iRow3 is the last row in the table (changes as new data is input):
With ActiveSheet.ChartObjects.Add(Left:=Range("C12").Left, _
Top:=Range("C12").Top, _
Width:=Range("C12:G24").Width, _
Height:=Range("C12:G24").Height).Chart
.ChartType = xlXYScatterLines
.SetSourceData Source:=Sheets("FT1 Data").Range("Y2:AD" & iRow3), _
PlotBy:=xlColumns
.HasLegend = False
End With
Although the table spans 4 Columns (Y, Z, AA, and AB), I would essentially like to have 3 separate charts with Y being the x-axis increments for all the charts and the latter three representing the y-values for the 3 different charts. How would I go about doing that?
Help is much appreciated! Thanks in advance!
With ActiveSheet.ChartObjects.Add(Left:=Range("C12").Left, _
Top:=Range("C12").Top, _
Width:=Range("C12:G24").Width, _
Height:=Range("C12:G24").Height).Chart
.ChartType = xlXYScatterLines
.SetSourceData Source:=Sheets("FT1 Data").Range("Y2:AD" & iRow3), _
PlotBy:=xlColumns
.HasLegend = False
End With
Although the table spans 4 Columns (Y, Z, AA, and AB), I would essentially like to have 3 separate charts with Y being the x-axis increments for all the charts and the latter three representing the y-values for the 3 different charts. How would I go about doing that?
Help is much appreciated! Thanks in advance!