Create XY Scatter plot Bubble

I have a sample dataset with 3 series on Y axis and year range on X axis. I have plotted XY Scatter plot manually, however if Y axis data range is more than 5 data series (e.g. 10, 15) it become very combursom to plot a chart.following are the steps to create chart

1. Insert blank row against each column
2. Enter data series for each column (for this example 3)
3. Insert Scatter Bubble plot based on the new dataset

I have enclosed a small dataset for reference. I would appreciate any help for creating VBA based Macro