Change the chart title to Annual Sales Analysis.8. Click the Preset gradients button and then click ‘Light Gradient - Accent 3’ in the gallery. On the Fill & Line tab, if necessary, click Border, and then click Gradient Line. Click an empty portion of the chart to display the Format Chart Area task pane. In the Units area, type 2000000 in the Major text box.h. To narrow the range in the chart area and thus make the bars seem larger, in the Bounds area, type 8000000 in the Maximum text box. Click the Axis Options tab (Format Axis task pane) and expand Axis Options. Click the x-axis or horizontal labels at the top of the chart to display the Format Axis task pane. Repeat step 7e for the data bars representing the Returns.g. In the gallery, click the Soft Round style.f. On the Effects tab, click the 3-D format area, and then click the Top bevel button. On the Fill & Line tab, add a black, solid line border to the series.
#THE QUICK ANALYSIS BUTTON DATA SERIES#
With the task pane still displayed, click any of the data bars that represent Sales to display the Format Data Series task pane. In the Axis position area, reverse the order of the categories.e. Right-click the y-axes or vertical labels. Click any of the data labels (the numbers on the bars themselves), and press the DELETE key to delete the data labels.d. Change the chart style to Style 3 (Chart Tools Design tab | Chart Styles group).c.
With the chart selected, click the Change Colors button (Chart Tools Design tab | Chart Styles group), and then click Color 4 in the gallery.b.
Use the Quick Analysis gallery to insert a Clustered Bar Chart. Click the Quick Analysis button, click Totals, and then click the second Sum button to create row totals. Copy the formatting from cell E3 to F3.5. In cell F3, type Total to enter a column heading. Use a Cell Style to create a double-underline below the totals.4. Click the Quick Analysis button, click Totals, and then click Sum. In cell A6, type Net Sales to enter a row heading.3. Save the file with file name Lab 7 – 1 Custom Fragrances Complete.2. Open the workbook, Lab 7– 1 Custom Fragrances from the Data Files. Please contact your instructor for information about accessing the Data Files.Problem: Custom Fragrances has prepared an annual sales analysis but would like to show the data in a more visual way, along with grand totals (Figure 7–94).Figure 7–94Instructions Part 1: Perform the following tasks:1. This problem has been solved: Solutions for Chapter MEM7 Problem 1L: Using the Quick Analysis Gallery and Formatting a Bar ChartNote: To complete these steps, you will be required to use the Data Files.
0 kommentar(er)
