Question: 7 . Switch to the Process worksheet. Create a Scatter with Straight Lines chart based on range D 6 :I 1 4 in the data

7. Switch to the Process worksheet. Create a Scatter with Straight Lines chart based on range D6:I14 in the data table Process Consulting Net Income Analysis.
8. Modify the new chart as follows:
a. Resize and reposition the chart so that it covers the range D15:I32.
b. Remove the chart title from the chart.
c. Reposition the chart legend to the right of the chart.
d. Add Net Income as the vertical axis title and Hours Contracted as the horizontal axis title.
e. Change the colors of the chart to Monochromatic Palette 1(1st row in the Monochromatic palette).
9. Change the Bounds Axis Options for the new chart as follows:
a. Change the Minimum Bounds of the vertical axis to -100,000 and the Maximum Bounds to 650,000.
b. Set the horizontal axis to cross at the axis value -100,000.
c. Change the Number format of the vertical axis to Currency with 0 Decimal places and $ as the Symbol.
d. Change the Minimum Bounds of the horizontal axis to 3,500 and the Maximum Bounds to 7,500.

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!