VBA plot a Scatter graph data - X and Y axis data taken from sheet row by row
The data is time series data thus each row of X and Y data must be plotted from the respective worksheet row (20 columns of data per row)
This needs to be automated via VBA to accept the data row by row - wish to expand this with more data hence the need for VBA
Graph needs to appear like a Polygon as shown in the image I've also added some example data at the bottom of this post
Example.jpg
DATA.xlsx