You may find it useful to animate the elements of a chart or table. For example, you may want to discuss sales of one product throughout all the quarters of the year before going on to the next product. Or you may want to explain a table row by row.
To add animation to charts, follow these steps:
- You can add animation to charts. Bar charts look good with a wipe up or wipe right effect.
- Choose Slide Show> Custom Animation (in 2007, Animations tab> Custom Animation).
- Select the chart and add animation as usual, by choosing Add Effect> Entrance>Wipe, for example. (If you don’t see the Wipe animation, choose More Effects.)
- Click the animation’s item in the task pane, and choose Effect Options.
- Click the Chart Animation tab.
- Use the drop-down list to animate the chart as one object, by series, by category, or by the elements in the series or category. Usually, one of these options is what you want.
You cannot animate part of a table in this way.
Because animating charts and tables does not break them up into individual objects, you cannot animate the individual elements in their original form. For example, you might want to animate the Axis labels of a chart so that they appear one by one, along with the bars. For that, you need to ungroup them.
To ungroup a chart or table in PowerPoint 2002/2003, select it, right-click it, and choose Grouping> Ungroup (for a chart) or Ungroup (for a table). At the message asking if you want to convert the chart or table, click Yes. Click the chart or table. If you don’t see lots of objects, ungroup it again. You may want to regroup the elements that you’re animating together.
Here you see a chart after displaying the first category and axis label.

Chart after displaying the first category and axis label
The table shows the result after displaying the first three rows.

Result after displaying the first three rows
To animated part of a table or chart in PowerPoint 2007, you need to use a different method, because you can’t ungroup them.
Note: When you ungroup a table or chart, you lose effects and non-solid fills. Also, editing the contents of the table will be more difficult. You may want to make a copy of the slide first to retain the full table. You can hide the slide. To hide a slide in 2007, go to Slide Show tab> Set Up group> Hide Slide. Alternatively, you can copy the table itself and drag the copy off the slide.
Warning! Before doing this process, be sure to format the table or chart the way you want it, including the size of the text, the solid fills, and the borders. The process will convert the table to lots of individual objects and formatting them all is quite difficult.
Microsoft has provided a workaround for 2007. Here are the steps:
- Select the table or chart and copy it to the Clipboard
- Go to Home tab> Clipboard group and click the Paste down arrow. Choose Paste Special.
- In the Paste Special dialog box, scroll down and choose Picture (Enhanced Metafile). This option results in a high-quality image. Click OK. Because the table was selected, the new pasted metafile replaces the original table. (A metafile is a vector type of image.)
- With the table still selected, go to Picture Tools Format tab> Arrange Group> Group> Ungroup (or press Shift+Ctrl+G).
- Click Yes to confirm converting the picture.
- The table is now a grouped object, so you need to ungroup it again. Choose Picture Tools Format tab> Arrange Group> Group> Ungroup (or press Shift+Ctrl+G).
To get ready to animate the elements, first check out what you have. With a table, for example, depending on the formatting of the original table, you may have:
- A rectangle around the entire table
- Lines that create the borders along the rows and columns
- Rectangles that create solid fills for the cells
- Text boxes with the contents of each cell
You should group together elements that you want to animate together. Delete elements that you don’t need. For example, you may not need the rectangle that borders an entire table, so you can select and delete it.
To group elements, select them and choose Drawing Tools Format tab> Arrange group> Group> Group (or press Ctrl+G). When you’re doine grouping elements, you’re finally ready to animate them, as described earlier.
Related posts:






[...] Animate a chart or table September 27th, 2010 | Tags: anticipation, attention | Category: Delivery [...]
Hello,
Thanks for the tips. Animating tables is needed very often and the method you suggested is a lot better than messing around with disappearing “white boxes”, that some commonly use.
I’m glad to help! Yes, I’ve seen the disappearing white boxes and they can get messy. Also, if you need to edit the table, it’s so difficult with all those white boxes on top!
Hi Ellen,
I am trying to pull a list of first name, last name and organization from an excel 2007 worksheet and placing this list of names into a powerpoint 2007. My objective is to be able to place the list of names into a SmartArt list and then animate each name individually. However, I want only about 8 names per PPT slide. I can’t find a way to “split” the table to continue onto the next slide. Is there a way to convert the excel list into powerpoint easily or should I just rewrite the names and animate as I would like.
I think this might help you: http://www.ellenfinkelstein.com/pptblog/expand-one-slide-into-two/
So, you would paste all the names into one slide, all as bulleted text, then expand the slide into 2 (or more), then convert them to SmartArt. Does that help?
Hey folks, you are trying to move a chesspiece with a rocket launcher here. Since this thread shows up in the top 10 on Google for this problem, I thought I’d let you know what I figured out.
1. Create your table header and first row – you’ll want to decide on the correct number of columns, use two rows.
2. Duplicate that, delete the header, and move that down – now you have a second row which Bill’s silly program sees as a separate table, and which has the same formatting as the first.
3. Repeat to your heart’s content.
4. Once you’re done – or at any point – animate away!
KK
That’s a nice technique and I haven’t seen it before. Too bad the table doesn’t remember the spacing when you duplicate (the way it does with shapes), so you have to nudge each row into place each time. It’s a little difficult if you’re using alternating row colors, but otherwise works well.
Hi Ellen,
I am using PowerPoint 2007. I would like to add effects by elements in a series but I do not see it in the drop down list on the Animation Tab. I only see as one object, by series and by category as my choices. What am I doing wrong?
I’m seeing 5 choices on the Chart Animation tab of the dialog box, including By Element in Series and by Element in Category. I doubt you’re doing anything wrong, but the options might depend on your data and the chart type. Try inserting another chart, using the default chart type and default data and see what you get.
Hi Ellen,
I tried this with a bar chart and I did see 5 choices. However, I need to do this with a scatter plot and I am not given that option. Any suggestions?
Heidi
Very helpful, but I’m having trouble figuring out how to do something else. Hopefully you can help.
In a slide in one of my PowerPoint presentations, I’m using the “Tilted Matrix” chart. It has 4 boxes all correlating to a theme in the middle box. What I would like to do is enlarge one box to a full screen size to go over each section. Then have the enlarge box return to the chart and the next box enlarge. Is that possible? I don’t know if I’ve confused you at all haha.
This might help: http://www.ellenfinkelstein.com/pptblog/easily-create-flexible-diagrams-that-look-professional/
It explains how to ungroup SmartArt — Does “tilted matrix” refer to SmartArt? Then you can animate the separate objects.