Join Richard Harrington for an in-depth discussion in this video Viewing chart animations, part of Excel 2013: Working with Charts and Graphs.
- As you make changes to a chart or the table, it will continue to update its appearance. One of the things that's new inside of Microsoft Excel 2013 and future versions after that is the ability to animate data. Now, this animation is not meant to be something that you put into a presentation on its own. I'll quickly show you that in a second. But rather, as you change things and want to visualize those impacts or perhaps you were showing a colleague what changing data would do or if a movement occurred in the target audience, you could see what happens in the chart with a smooth transition.
Let me show you. I'll start by putting these things side by side to make it a little bit easier to see everything. Remember, you can grab the top edge of a chart and move. Let's also just make this data here a little bit thinner. I'll reduce the size of this column so it fits a bit better. All right. With this in mind, let's choose both elements. I'll just shift click.
And from the View menu I'll tell it Zoom to Selection. Now, that fit the chart into the window and on the left-hand side here we have the data. Now, as we change data, you'll see things update here on the right. Now, if we make a change that forces the total axes to redraw, it takes a second to redraw the left column. But now any other change that I enter, and I press return, smoothly animates on the chart itself.
This is useful if you want to help a colleague understand the impact of changes. If you want more complex animation, simply highlight the chart and with a right-click you could choose Copy and then simply launch PowerPoint. On a blank slide, you could choose to Paste this. Now, you'll note different options. You could choose to keep the theme of the destination so it takes on the look of the slide or keep the original formatting from Excel.
It's up to you. Do you change it to match the new template or preserve what you had? Once that's added, you can scale this. And you'll note that we have an Animations category. Simply select the elements that you want to animate. We'll choose the chart here. And I'll select a category here to Wipe this on. Let's choose to do this by individual series.
And you see the data grows. Now, if you look at the individual animation pane here and you expand this, you could see what happens. By default, it's set to start with a click, but I could tell the information to automatically start after the previous. And when we play this you'll see the animation builds on over time. Now, this is not a full course on Microsoft PowerPoint. You'll find a ton of courses available in the Lynda.com library to help you get more out of PowerPoint itself. I just wanted to show you that the chart animation features, which were newly added in Excel 2013, are really meant to just help you understand the data or to clearly see the impact as you make a change.
If you were presenting a spreadsheet and people asked you to project what might happen if the data were to change or the company were to see growth, the graphic that you have built will update in a smooth fashion. If you truly need more complex animation, then it's time to move onto Microsoft PowerPoint, which will have a whole range of tools at your fingertips.
- Creating a chart
- Picking a chart type
- Displaying data with tables
- Editing data in a chart
- Adding SmartArt graphics