Just make your range:
The xvalues is only a row - maybe your header row? - representing what you want along the x axis.![]()
ActiveChart.SeriesCollection(1).Values = "=test2!A4:B" & LastRow
Just make your range:
The xvalues is only a row - maybe your header row? - representing what you want along the x axis.![]()
ActiveChart.SeriesCollection(1).Values = "=test2!A4:B" & LastRow
MatrixMan.
--------------------------------------
If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks