Southern Cross Faculty of Science University and Engineering Question 3 (30 Marks) a) Record a macro that will plot a pie chart and a bar chart that displays the following information (Data is given in the Excel file) (15 Marks) b) Create a button that once clicked, it will generate these figures automatically. (15 Marks) Numerical Analysis | Assignment 1 | Assignment 2 |Exam Weight 25% 25% 50% Weight Weight 60% 50% 40% 30% 20% 101% 0% . Assignment 1 . Assignment 2 . Exam Assignment 1 Assignment 2 Exam (You do not need to plot the figures the same as shown here) MATH3003 Computational Analysis Term 4, 2022