• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint


Q1:I get confused between the data series and categories. What's the easiest way to work with these concepts?
A1: If you don't create charts on a daily basis, confusion is normal. The best way to understand them is through trial and error. Use the generic datasheet to set up your original data the way it makes the most sense to you. Then, if necessary, realign it using the Data menu in Microsoft Graph.
Q2:I finally got my chart to look really good. Is there a way to reuse it?
A2: When you access the Chart Types dialog box under the Chart menu in Microsoft Graph, click the Customize tab, uncheck Built In, and check User Defined. Now you can add this chart to your Customized Chart Gallery by clicking Add, and you can apply this as a chart type to any datasheet.

You'll see a dialog box that enables you to name and describe the chart, which is added to the default chart under the User Defined Customized area.

Also, think about what we did in Hour 7, “Beginning to Use Charts,” when we pasted the data from one datasheet into Excel. When you have the format of a chart the way you like it, you can paste another set of data into it. Generally, you'll want to use similar charts with similar sets of data—pasting a column chart datasheet into an area chart might not give you the best results.

We'll cover a number of additional strategies in Hour 11, “Working Smarter Not Harder.” These involve templates and copying slides between presentations.

Q3:Is there a way to show the data incrementally? For example, one bar at a time?
A3: Let's not get carried away. This was a long hour. We'll deal with animation in Hour 13, “The Power of Animation,” and yes, you can apply incremental entry animations to all Microsoft Graph charts.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint