Question: Use the Axis Options to display the value axis in units of Thousands, set the Major Units to 500 , apply the Number format with
| 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. Use the Axis Options to format the category axis so that the category labels are in reverse order in the bar chart. |
| 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). |
| Apply a gradient fill, using any preset or color, to the plot area in the bar chart. |
| Apply landscape orientation for the Data worksheet. |
| Apply horizontal and vertical centering on the page options for the Data worksheet. |
| 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
