Question: VBA coding: The user will input between 3 and 20 data points for two variables on Sheet1 starting in cells A2 and B2 (the program

VBA coding:

The user will input between 3 and 20 data points for two variables on Sheet1 starting in cells A2 and B2 (the program should work if 3,4,5,...,20 data points are entered.) Column A will contain the values for variable x and column B will contain the values for the variable y. Call a sub procedure named GetInput that obtains the x and y values from Sheet1 and stores the data in a 2D array named xyvalues. Add code that will automatically generate a scatter plot containg the following information: -N data points -the best-fit line -labels for the x and y axis - chart title. This code needs to be written in VBA, so the plot shows automatically after the macro is run, meaning there is no use of the Insert-Chart options in the Excel workbook.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!