Question: In cells C 4 0 - J 4 0 , insert a Scatter Chart for the demand and supply curves from parts ( a )

In cells C40-J40, insert a Scatter Chart for the demand and supply curves from parts (a) and (b).
Inserting a Chart
On the Insert tab, in the Charts group, click the arrow next to Insert Scatter (X,Y) or Bubble Chart and choose Scatter with Straight Lines Chart.
Selecting Data Series
Then in Select Data Source window, delete any series created automatically.
Add new series for the initial demand curve using cells D13-D18 for the X values and cells C13-C18 for the Y values. Use D1 as the series name.
Add new series for the initial supply curve using cells E13-E18 for the X values and cells C13-C18 for the Y values. Use S1 as the series name.
Add new series for the new demand curve using cells D28-D33 for the X values and cells C28-C33 for the Y values. Use cell D2 as the series name.
12 Add new series for the new supply curve using cells E28-E33 for the X values and cells C28-C33 for the Y values. Use S2 as the series name.
Edit Chart Elements bound.
Chart Size and Position
Set the chart height and width so the entire chart fits within cells C40-J40.
Note: Be sure to use capital letter for series names.
13 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
 In cells C40-J40, insert a Scatter Chart for the demand and

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!