Using PowerPoint with Excel

Option 1 for Chart Integration

The next slide in the presentation is the budget distribution chart. Cameron will create a chart from scratch in a new slide. He opens the New Slide options and selects Content with Caption, then types in the title in the box. He moves the cursor over the large box and clicks on the Insert Chart icon and decides on the type of chart.

For this slide, he selects a 3-D Pie chart. A small Excel spreadsheet pops up above the pie chart for Cameron to enter the data for the chart.





Cameron begins to type in the data by double-clicking on a cell and replacing the text or numbers in it. He changes the numbers cells to percentages. There is an extra row he doesn't need, so he selects it, right-clicks, and selects the Delete Row from the menu. Cameron now clicks the X in the small window and closes it.





Cameron decides to show the budget present age on the chart and needs to modify a few other aspects about the chart to make it easier to see.

He takes the following steps:

1. Chart Elements Button. This + button allows Cameron to change aspects of the chart.
2. Elements List. Cameron clicks the Data Labels box to change the labels.
3. Arrow Button. Cameron clicks the small right arrow, and a new menu appears.
4. Data Label List. Cameron moves the chart numbers to the center of their respective areas.
   

Next, Cameron changes the area numbers to percentages and increases the font size of the chart text and the Store label sizes.

The chart is now too close to the store labels. Cameron clicks on the chart and hovers over the border until the four-arrow cursor appears. He drags the chart up, closer to the title. This centers the chart and makes it easier to read the labels.