8 Apply the Accounting Number Format to the first row of
6.000 sales figures and to the total row . Apply the Comma Style to the remaining sales figures .
9 Select the range that represents the sales figures for the
10.000 three months , including the month names and the product names — do not include any totals in the range . With this data selected , use the Recommended Charts command to insert a Clustered Column chart with the month names displayed on the category axis and the product names displayed in the legend .
10 Move the chart so that its upper left corner is positioned 3.000 in cell A10 .
11 Apply Chart Style 5 and Color 3 under Colorful . Modify
13.000 the Chart Layout by applying Layout 1 . Change the Chart Title to1st Quarter Oven Steamer Sales .
12 In the range F4 : F7 , insert Line sparklines that compare 10.000 the monthly data . Do not include the totals . Show the