Answered step by step
Verified Expert Solution
Question
1 Approved Answer
VBA with Excel: I have a 2D array with as 3-20 (N) data points. Add code that will automatically generate a scatter plot containg the
VBA with Excel:
I have a 2D array with as 3-20 (N) data points.
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started