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)
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
<img src='https://i.imgur.com/jkP1dPA.png' />
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)
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
<img src='https://i.imgur.com/jkP1dPA.png' />
