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

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.
Modify the new chart as follows:
a. Resize and reposition the chart so that it covers the range D15:132.
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 Jvertical 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).
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 Syrmbol.
d. Change the Minimum Bounds of the horizontal axis to 3,500 and the Maximum Bounds to 7,500.
Edit the chart series names as follows:
a. For Series 1, use cell E5 as the series name.
b. For Series 2, use cell F5 as the series name.
c. For Series 3, use cell G5 as the series name.
d. For Series 4, use cell H5 as the series name.
e. For Series 5, use cell I5 as the series name.
 Switch to the Process worksheet. Create a Scatter with Straight Lines

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!