Insert A Waterfall Chart Based On Cells A1 B10

Question: Change the shape outline color to Orange, Accent 2. It is the sixth option in the first row of the color palette.

Answer: In the Format Ribbon Tab in the Shape Styles Ribbon Group, you clicked the Shape Outline button arrow. In the Shape Outline menu, you selected the Orange, Accent 2 color option.

Question: Insert a Line chart based on the first recommended chart type.

Answer: You clicked the Quick Analysis Tool button, clicked the Charts tab header, and clicked the Line button.

Question: Insert a Waterfall chart based on cells A1:B10.

Answer: In the Insert Ribbon Tab in the Charts Ribbon Group, you clicked the Insert Charts Group Dialog Launcher dialog launcher. You clicked the All Charts tab. Inside the Insert Chart dialog from the Chart Type list, you selected Waterfall. Inside the Insert Chart dialog, you clicked the OK button.

Question: Apply the Colored Fill - Green, Accent 6 Quick Style to the shape. It is the last option in the second row of the gallery.

Answer: In the Mini Toolbar, you clicked the Fill button, clicked the Style button. In the Shape Styles Gallery menu, you selected the Colored Fill - Green, Accent 6 option.

Question: Apply the Style 7 Quick Style to the chart.

Answer: In the Design Ribbon Tab in the Chart Styles Ribbon Group, you expanded the Chart Styles Gallery. In the Design Ribbon Tab in the Chart Styles Ribbon Group in the Chart Styles menu, you clicked the Style 7 gallery option.

Question: Clear the selected Sparklines from the worksheet.

Answer: In the Design Ribbon Tab in the Group Ribbon Group, you clicked the Clear button arrow. In the Clear menu, you clicked the Clear Selected Sparklines menu item.

Question: Display the data labels on this chart above the data markers.

Answer: You launched the Chart Elements menu. In the Mini Toolbar in the Data Labels menu, you clicked the Above menu item.

Question: Change the gridlines to use the Dash (dash style).

Answer: Right-clicked the Chart Element chart element. In the Gridlines Right-Click menu, you clicked the Format Gridlines… menu item. Inside the Format Major Gridlines dialog from the Format Gridlines list, you clicked the Dash type item. In the chart Gridlines Dashes menu, you selected the Dash option.

Question: Add column Sparklines to cells F2:F11 to represent the values in B2:E11.

Answer: In the Insert Ribbon Tab in the Sparklines Ribbon Group, you clicked the Column button. Inside the Create Sparklines dialog, you typed F2:F11 in the Location Range input, clicked the OK button.

Question: Move the selected chart to the empty area of the worksheet below the data.

Answer: You dragged the chart to the left (by 4 columns) and down (by 4 rows).