Animate an Excel Chart in PowerPoint (Office 2003)
Excel charts aid in the interpretation of data. If you are displaying the chart in a PowerPoint show, an effective way to display the chart is one column at a time.
Step 1 - Create a chart in Excel. If you need assistance with that step, take a look at an online module on the topic . For this module, a chart on Memphis rainfall was created.
Step 2 - After the chart has been created, click in the white area surrounding the chart to select the entire chart. Copy the chart by holding down the Ctrl key before you tap the C key. (Note: right-clicking to copy is not available to copy an Excel chart.) You will know the chart has been copied when you see the "marching ants" around the entire chart.
Step 3 - Open PowerPoint and select blank slide for slide one. Paste the copied chart onto the slide by holding down the Ctrl key and tapping on the V key one time.
Step 4 - From the Slide Show menu on the Menu bar, select Custom Animation . A Custom Animation pane opens on the right side of your screen. If Add Effect is grayed out, the chart was not selected before you went to this step. Click on the chart one time and Add Effect will be available. Select Entrance and then Dissolve In . If you do not see Dissolve In click on More Effects . (Note: some animations will not work for chart animation)
Step 5 - After selecting the effect, a rectangle with a green star appears just below the effect speed block. Click on the down arrow at the right end of the rectangle, and choose Effect Options.
Step 6 - When the Effect Option dialog box pops-up, select the Chart Animation tab. What you select next depends on how you want the columns to appear on the chart. Using the chart seen below step 1 above, here is what the choices would mean:
By series would display all of the red bars at once, and then a click would display all of the yellow bars
By category would display both bars in a month, and then a click would display the next month
By element in series would display the January red bar and then a click would display the February red bar
By element in category would display the January red bar and then a click would display the January yellow bar
Step 7 - Before you click OK in the window seen above, click in the box labeled Animate Grid and Legend to deselect that option. You may try it both ways, but I prefer to have the basic chart on the slide as soon as the slide is displayed. That is just personal preference however.