How to Animate Excel Charts in PowerPoint
Pinterest Whatsapp
Advertisement

PowerPoint presentations with lots of data don’t have to be boring. Excel makes it easy to take multiple lines of data and convert them into easy to interpret visual charts. When you pair your data with PowerPoint, you can animate Excel charts to create an engaging presentation 10 Tips for Making Better PowerPoint Presentations with Office 2016 10 Tips for Making Better PowerPoint Presentations with Office 2016 Microsoft PowerPoint continues to set new standards. New features in PowerPoint 2016 manifest its top spot as the best option for smart and creative presentations. Read More .

We’ll take you through the process step by step. Watch your data come to life.

Creating Your Chart

The first step in animating Excel charts is to create your chart with the data that you’ve compiled. If you’re not sure what kind of chart is right for your data, take a look at this guide on picking the right Excel chart 8 Types of Excel Charts and Graphs and When to Use Them 8 Types of Excel Charts and Graphs and When to Use Them Graphics are easier to grasp than text and numbers. Charts are a great way to visualize numbers. We show you how to create charts in Microsoft Excel and when to best use what kind. Read More for you.

If your data changes on a regular basis and you have to give a monthly presentation for example, you can create self-updating charts in Excel How to Create Self-Updating Excel Charts in Three Easy Steps How to Create Self-Updating Excel Charts in Three Easy Steps We'll show you how to make your Excel charts self-update. Just add new data and watch how they automatically show up in your graph. It's quick and easy. Read More and take them over to PowerPoint to animate them.

If you’re creating a one-time chart, you don’t even have to open Excel on your computer. You can start right in PowerPoint by going to Insert > Chart you can choose your type of chart, and add the data with a little Excel popup right there in the program.

If you don’t have a lot of data, you can actually design a pie chart right in PowerPoint, using the app’s shapes feature.

PowerPoint’s Animation Menu

Once you’ve got your chart ready to go, you can copy it into PowerPoint to animate it. Click on your chart or graph and use the keyboard shortcut Ctrl + C to copy it. Open a blank canvas in PowerPoint, and use the keyboard shortcut Ctrl + V to paste it.

In PowerPoint, you’ll spend all your time in the Animation tab. This is where you’ll find all the tools you need to animate charts in PowerPoint.

You should see a small selection of animations in the menu at the top of the screen. Click the arrow at the end of the animations to see all animations available to PowerPoint users.

Animating a Bar Chart

In our example, we’re using the data from the Expense Trends Budget spreadsheet template, which includes a bar graph.

The best option for a bar graph is for it to appear from the bottom of the screen going up. The Wipe animation is a suitable choice for this kind of movement.

To apply the animation, do the following:

  • Click to select the graph.
  • Click the Wipe animation button.
  • The animation will be applied to the entire graph.

animate excel charts in powerpoint

Next, you’ll want to change the advanced settings for your animation, so that it appears gradually rather than in one go.

These settings are found under Effect Options.

With Effect Options you can choose the direction of the animation — it can appear from the top, the bottom, the left, or the right. You can also determine how your chart will be animated: as one object, by category, or by series.

So what do these options actually mean?

  • By category: This animates your data by each category on the X-axis of your bar chart. If each category includes one bar, each bar will be animated individually. If there are multiple bars in each category, they will all be animated at the same time.
    animate excel charts in powerpoint
  • By series: This option animates your data by each individual color within a category on the X-axis of your bar chart. Each set of bars of one color will be animated together.
    animate excel charts in powerpoint
  • By element in category: This option animates your data by each category on the X-axis, but slows down the animation considerably. Each bar will animate one after the other, so if you have a chart like the one below, it will simply animate each bar in the order in which it appears in your graph.
    animate excel charts in powerpoint
  • By element in series: Each series (or set of bars of one color) will be animated individually. Each bar of one color will animate individually one after the other, followed by the next color.
    animate excel charts in powerpoint

For each of these options, you can also check Start animation by drawing the chart background. This will allow the background to gradually appear before your graph elements begin to appear.

If you don’t like the appearance of your animation, you can test other options by clicking on the animation name in the tab. The effects that you applied will be maintained with the new type of animation.

To see the whole process in action, check out the video below:

Choosing the Right Animation for Your Chart

As we mentioned, there are plenty of different types of charts available in Excel. The chart you use depends on the nature of your data, and the animation you use for that chart depends on the type of graph you’ve chosen.

In addition to the default chart animations that are visible in the menu, you can view more entrance, exit, and emphasis animations by clicking the down arrow at the end of the animation list.

animate excel charts in powerpoint

You can see even more animations by clicking More Entrance Effects in that pane.

  • Bar Charts: For bar charts like the one in the example above, the Wipe, Peek In, and Fade would all work well.
  • Pie Charts: For pie charts, try the following animations: Wheel, Zoom, and Fade. In the GIF below, you can see an example of a pie chart animated with the wheel effect.
    animate excel charts in powerpoint
  • Stacked Area: For stacked area charts, try the following animations: Fade, Appear, or Wipe. In the GIF below, you can see an example of a stacked area chart with the fade effect.
    animate excel charts in powerpoint
  • Line Charts: A good choice for line charts is Wipe, but be sure to select the animation direction from the left.
    animate excel charts in powerpoint

There are other ways you can customize your animation to suit the kind of chart you are using. Open the Animation Panel and in the menu click Timing. Under the timing panel, you can control how fast your animation appears, whether you need to click for the animation to appear, and whether the animation should be repeated.

Experimentation Is Your Friend

You’re probably going to find yourself testing different animations and different options to see what works best for your data, graph, and presentation style. Testing different options and speeds will ensure that you find the setting that is right for you.

Once you’ve done it a few times, the process of animating Excel charts will be much faster.

What kinds of charts 6 New Excel Charts and How to Use Them 6 New Excel Charts and How to Use Them Need to get more out of your Excel charts? Here's a one-stop guide to some of the new charts introduced in the latest version of Excel. Read More do you use for your Excel data? Is there a different program or tool you prefer to use to animate your charts? Let us know in the comments.

Image Credit: IgorTishenko/Depositphotos

Enjoyed this article? Stay informed by joining our newsletter!

Enter your Email

Leave a Reply

Your email address will not be published. Required fields are marked *