How To Animate Excel Charts In Powerpoint

powerpoint charts, just like illustrationsin a book, are designed to help you illustrate your point. things like color, layout, andeven the chart type can all be changed to better fit the information you're trying toconvey. take this account of our book store's salesfigures. right now, the columns are grouped by genre, but i'm more interested in takinga look at trends over time - which means grouping

How To Animate Excel Charts In Powerpoint, the data by year. there's an easy way to changethat. just make sure your chart is selected. then, from the design tab, click the editdata command; this opens an excel worksheet. now click back to powerpoint and choose switchrow/column. see how that rearranged the data? basicallythe years and the genres have switched places.

you can always experiment with this to seewhich option is going to work best. if you want to try a different chart all together,you can click change chart type, and pick something else from the dialog box. i thinki'll go with a line chart this time. line charts work well for data like this.for example, we can see right away that classics had an unusually good year in 2007, and alsothat mysteries are starting to catch up to romance novels. the lines would be easier to see, though,if they were thicker. let's see if we can change that by selecting a different chartstyle. just click the arrow here to open the full menu. that's much better.

the last thing i'd like to change is the chartlayout itself. we have lots of layouts to choose from - not all of them will work forthe data you're trying to present. just keep going until you find the one you like. howdoes that look? as you can see, customizing your chart iseasy - and with everything available on the design tab, you can achieve exactly the lookand feel you want.