Question: pls help! 11 Select the range A4:E10. Create a stacked bar chart. Move the chart to new sheet. Type Bar Chart for the sheet name.
pls help!
| 11 | Select the range A4:E10. Create a stacked bar chart. Move the chart to new sheet. Type Bar Chart for the sheet name. |
| 12 | Add a chart title above the bar chart and type November 2018 Weekly Downloads by Genre. Apply bold and Blue font color to the bar chart title. |
| 13 | Apply 11 pt font size to the category axis, value axis, and the legend for the bar chart. |
| 14 | Use the Axis Options to display the value axis in units of Thousands, set the Major Units to 500, apply the Number format with 1 decimal place for the bar chart. Click the vertical axis, and under Axis Options, click the Categories in reverse order check box. |
| 15 | Change colors and apply Monochromatic Palette 8 to the bar chart (Blue gradient, light to dark). Note, if you do not have Monochromatic Palette 8, apply Color 12 (Blue gradient, light to dark). |
| 16 | Apply a gradient fill, using any preset or color, to the plot area in the bar chart. |
| 17 | Apply landscape orientation for the Data worksheet. |
| 18 | Apply horizontal and vertical centering on the page options for the Data worksheet. |
| 19 | Ensure that the worksheets are correctly named and placed in the following order in the workbook: Bar Chart, Data. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
