CIS Ch3 Excel

Apply the Style 7 chart style to the chart.

Design and one of those big picutes on the window

Move the chart to its own sheet named Revenue Breakdown.

Use the Move Chart button [Chart Tools Design tab, Location group].

Display the Format Data Labels task pane, choose the Accounting format and set 0 decimal places.

[Label Options button, Number group],

Apply the Woven mat texture fill (first row, fourth column) to th.e Patio and Furniture slice.

chose a slice, right click, fill and chose the theme.

add data labels to display in the center of each slice

chose all pie, right click, add data lables.

Add another data series to the chart to represent the number of items ordered. Use the value of cell B1 as the series name and cells B2:B4 as the series values. Do not rebuild the chart from scratch

click add button and then click cells that needed to be inserted to the data windows like on the pic. (On the Chart Tools Design tab, in the Data group, click the Select Data button. In the Select Data Source dialog. click the Add button. Click cell B1 to enter it in the Series name box. Click in the Series values box and delete the default entry. Click and drag cells B2:B4. Click OK to add the new series. Click OK to accept the change to the chart data source.)

Open format data series in the chart. Change the explosion for the Room and Cabin Rentals slice to 10%

double click the chart

display the data labels on this chart above the data markers

you launched the chart elements menu, in the mini toolbar in the data labels menu, you clicked the above menu item

Set the last data point (March Net Income) as a total.

Double click the March net income data point to open the format Datapoint task pane. In the task pane, click the set as total checkbox

display the data table, including the legend keys

Click the Chart Elements button and click the Data Tables check box.

modify the chart so total data series are ploted along secondary axis

On the Chart Tools Design tab, in the Type group, click the Change Chart Type button. In the Change Chart Type dialog, click the Secondary Axis check box next to the Total series.

The August Purchase Orders data point has been selected for you. Rotate the pie chart exactly 130° so this data point appears at the right side of the chart near the legend.

On the Chart Tools Format tab, in the Current Selection group, click the Format Selection button to open the Format Data Point task pane. In the Angle of first slice box, type the 200 and press Enter.

Insert a Left Arrow block shape to the right of the Jan column in the chart

On the Insert tab, in the Illustrations group, click the Shapes button and select the Left Arrow shape from the Block Arrows section. The cursor changes to a crosshair. Click on the chart to the right of the Jan column