Automation of Output Computations and Plots generation

Dear All,

Can somebody help me out in generating a macro for Automation of Output calculations and Plots generation? Generate Plots of type “XY Scatter with Smooth lines and Markers”.- I have clearly mentioned the requirements in Excel sheet enclosed (Please refer S.No.1)

Requesting you to please get me an Excel Macro for this.

Apart from the two components such as Bearing & Bushings calculations shown in the Excel sheet, I have to extend these calculations and plots generation to 20 more components. So, please make provision for the same in VB macros.

Thanks in advance,
reachspk123

(Note: Please do not use Excel cell reference formulae anywhere in the sheet. I request you to perform calculations using VB macros only.)