微软office 2010中文官方培训课件-powerpoint 图表和图示 2：数据图表

Note to trainers,The videos in this presentation provide closed-caption files as its often easier for viewers of all abilities to follow along. If you wish to remove the closed captions, you must install the Subtitling Add-in for Microsoft PowerPoint (STAMP). You can download the add-in from /projects/stamp-addin/files/Latest%20Version/ Once you install the add-in, to turn the captions off: Locate a slide that contains a video and click the video. The Playback contextual tab appears on the top of the window. If you dont click the video, the Playback tab wont be visible.On the Playback tab, click Hide.Go to the next slide and repeat until youve hidden the captions all slides or for any of the videos with captions you wish to hide. Note that if you save the file, the captions will stay hidden when you re-open the presentation.To show the captions again, repeat steps 1-3, but click Show in step 2. If you click Remove during step 2, the captions will be permanently removed from the video.,Before you begin,If a yellow security bar appears at the top of the screen in PowerPoint, click Enable Editing.,You need PowerPoint 2010 to view this presentation. If you dont have PowerPoint 2010, download the PowerPoint Viewer (see the URL in the notes pane).,Microsoft PowerPoint 2010 Training,Data charts in PowerPoint,Course contents,Overview: Charting basicsLesson: Includes 5 instructional moviesQuick Reference Card,Data charts in PowerPoint,Overview: Charts in PowerPoint,Data charts in PowerPoint,Learn how to visualize data by inserting data charts using PowerPoint 2010. Learn the fundamental components of a chart, and learn how to work with pie charts, column charts, and line charts.,Course goals,Visualize data with a chart.Compare parts of a whole using a pie chart.Insert a column chart to show change over time.Define what a data series is.Define what a category is.Select and customize chart components.,Data charts in PowerPoint,Introduction (0:28),Data charts in PowerPoint,Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.,Welcome to Charts and Diagrams II.,In Charts one we explained how to visualize text using SmartArt.,In this course, well show you how to visualize data using charts.,For example: well cover the basics of pie charts, column charts, line charts, and so on.,So, lets get started!,Visualize data (3:48),Data charts in PowerPoint,Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.,Ive created a brand new blank slide here in my PowerPoint presentation and Im going to insert a chart,that represents some data into that slide. In fact I want to go ahead and show the quarterly sales for the year 2011,and I want to show how much was sold in each individual quarter.,So Im going to come up here to my Insert tab and Im going to choose Chart from the Illustrations section.,This opens my insert Chart dialog and Ive decided Im going to use a pie chart,because I think thatll best represent my four quarters of data.,Im going to keep it simple and verify that Ive select the simplest pie, the first one,and then Im going to go ahead and click OK.,Now immediately two things become apparent to me: One, I have a sample chart here with some sample data.,And two, I have a spreadsheet that appears which is directly linked to this chart.,Now Ive resized this and Im going to drag it here on top of our presentation so that we can see them both,at the same time because our data is linked and I want to demonstrate that for you.,So Ive got: 1st quarter, 2nd quarter, 3rd quarter, and 4th quarter, and the corresponding numbers.,Just as I do here for the text in my legend and the data in my chart.,So because theres a direct connection between this spreadsheet and my PowerPoint chart,that means that any numbers that I want to change here in Excel are immediately represented in the chart,in my PowerPoint presentation. Let me demonstrate that for you.,Im going to go ahead and select the first number for 1st quarter sales,and Im going to change it to something that represents my data.,Now that Ive typed it in, notice theres no change in the chart yet.,I have to confirm that entry by moving off of the cell, so Im going to use my down arrow and move off of there,Now notice immediately the chart changes,and the number I typed in is so much bigger than the others, it just takes over the chart.,But lets go ahead and type in another number, and I move off of it and now its represented immediately in the chart.,And I go one more time for the 3rd quarter and now the red opens. Now the last one,the 4th quarter is going to be Yellow. So were going to go ahead and type that number in as well,and I move off the cell, and there you are!,Now Im done entering data so I can simply close the Excel workbook and click away and theres my beautiful pie chart.,Now if I want to change any of those numbers I would go ahead and select the chart itself,and I would make sure that I was in the Design tab, under Chart Tools, and I would go ahead and choose Edit Data.,Now again, this opens the sheet and I have to resize it and bring it to you so that I can demo this for you.,Notice I want to change this 4th quarter number, that means that this Yellow section,notice my legend, is going to change size. So lets keep an eye on that,and Im going to type in the actual number there, move off of it and an automatic change occurs in my chart.,And once again now that Ive changed the data I can go ahead and close the chart,click away and Im left with a very good looking pie chart that represents my data here inside PowerPoint.,So thats a very basic introduction to inserting a chart that represents your data.,Insert a column chart (3:59),Data charts in PowerPoint,Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.,OK, so you saw how I inserted a pie chart. Pie charts are probably the most basic chart you can insert.,So lets insert a slightly more complicated chart; lets insert a column chart.,Now Ive gone ahead and created a blank slide here,and added it to my presentation so that I can insert the column chart.,So once again, in this slide, I want to go ahead and click the Insert menu,and then Im going to go ahead and choose Chart.,And Column is usually selected by default, but I just verify that anyway and click OK.,Now as it was with my pie chart, a chart is inserted on the slide,and the Excel spreadsheet that contains my data is opened as well.,Now the column chart is good to use when you need to show data changing over a period of time, so,lets make one that does that.,Well make a column chart that compares salesperson performance over the period of a year.,So how do we start filling out this spreadsheet? Well first I need to explain to you what a series is.,A series is the actual data itself that you are representing,the values of the data that you want to show up in these columns here.,In this case, each series will represent a salespersons amount sold.,So well type in the salespeoples names right up here along the top.,Where it says Series 1, Series 2, and Series 3, Ill put in Miller, Gellar, and Galore.,Notice right away how the names appear here in the chart, in this area called The Legend.,So now to get the correct data to be represented here in our bars:,Orange for Miller, and Blue for Gellar, and Red for Galore;,we need to go ahead and fill this area here with actual sales data and I happen to have that sales data.,And there we are! Now notice that we have three data series in this chart.,One for each salesperson, and notice here in PowerPoint,how the data series appear for each salesperson and they grow vertically up the chart.,Now all thats left are the categories, and what are the categories?,Well categories are the descriptions that appear along the bottom horizontal axis in the column chart.,This is often your units of time. So what were going to do here,is actually change this to Quarter 1, Quarter 2, Quarter 3, and Quarter 4.,Im going to show you a really neat way to do that.,Im just going to type in the abbreviation,and Im going to go ahead and use autofill by putting my cursor,over the lower right hand corner of this cell: clicking, and holding, and dragging down,and it automatically fills Quarter 2, 3, and 4.,Thats allowed us to put in Quarter 1, Quarter 2, Quarter 3, and Quarter 4.,Which if youll look over here in the chart itself, has immediately been changed.,Now that Im done inserting my data I can go ahead and close Excel, and then I can click away.,And we have a really good looking column chart that compares the salesperson performance,over the course of the year.,So to review: your categories are here on your horizontal axis.,And in a column chart, the horizontal categories are usually the time periods. And in this case:,Quarter1, Quarter 2, Quarter 3, and Quarter4.,The data series are represented by columns here, and they climb vertically in a column chart.,Thats how we insert a column chart.,Other chart examples (2:50),Data charts in PowerPoint,Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.,So, we just got done taking a look at how to create a column chart,and in doing so we talked about what a data series is and what a category is,and I thought Id show you some of the other charts where we plugged in,the exact same data we used for the salespeople in our pie chart,but as youll soon see, that data will be represented in a different way,depending on the kind of chart we are using.,So lets take a look the least different of the ones that Im going to show you.,Here on slide ten is a bar chart as opposed to a column chart, notice that the data series,represented by the bars run horizontal this time.,And noticed that categories run along a vertical axis.,So it gives a slightly different skew and in my opinion gives more emphasis to the amount sold,letting the data grow horizontally showing a kind of race if you will,with Galore out in front, at least for quarter two.,Now the next one that Im going to show you is called a line chart.,Notice that the data series are represented this time by lines,and the categories run along a horizontal axis.,So the idea behind the line chart is that we can see an overall view of the sales year,and still get an idea of any trends that occur.,For example we can see that Galore tends to trend downward,and we can see also where any given salesperson was in their sales amounts at any given point in the year.,The next chart Id like to show you is the area chart.,Area charts are a combination of line charts, column charts and even a pie chart.,Let me explain. Area charts emphasize the magnitude of change over time,and can be used to draw attention to the total value.,For example, data that represents profit over time can be plotted in an area chart to emphasize the total profit.,Well as you can see here, it says 16 thousand is a combination of everyones sales.,By displaying the sum of the plotted values,an area chart also shows the relationship of parts to the whole,and it helps reveal any trends. They are, as I said before,the combination of the pie chart showing the overall total,a column chart showing the individual amount of sales,and a line chart allowing you to see trends.,So this is the power of other examples of charts that you can utilize here inside PowerPoint.,Customize a chart (4:39),Data charts in PowerPoint,Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.,OK, we are back here at the slide from my pie chart and its a perfectly fine pie chart,but Id like to customize it to have it better meet my needs. I could just select the chart,then go up to the Design tab and choose a different chart style,and then I can choose a different chart layout, click away and Im done.,If I decided then that I wanted to change my data labels,I could click the chart again and I would go to the Layout tab, select the data labels, choose one from the list,and again click away and Id be done.,You can quickly change the overall appearance of a chart with these tools, here in the ribbon.,These quick changes are great if they meet your needs. But if you want to customize individual chart elements, you can.,Let me show you what I mean.,Im going to go ahead and remove all of the formatting that I just did,and with this chart selected, Im going to go ahead and go up to the Layout tab,and then Im going to come over here to the current selection area,where I have the drop-down list for chart elements.,I can choose the Chart Area, I can choose the Chart Title, the Legend,the Plot Area and the Data Series “Sales” inside of the Plot Area.,Each of these elements can be customized by you without much trouble at all.,Now we arent going to cover how to customize all of the elements,but we will pick a few to give you a general idea.,Lets go ahead and start by looking at the Chart Area.,If I click on the drop-down list for my elements and choose Chart Area,a gray box appears around the chart and none of the other elements appear to be selected.,The Chart Area contains all of the other elements,and exists as sort of a background or container for everything in the chart.,If I wish to format the Chart Area, I can in fact go here,to the Format Selection and change a number of things about the appearance of my Chart Area.,I could also go with my Chart Area selected to the Format tab where I can change those same exact elements.,Its completely up to you but since were here, lets go ahead and,give it a different colored background,and we will click to the drop-down list for Shape Outline and choose a dark red outline,and well give it a little bit of weight.,Then once weve done that and we click away, the chart tools disappear,and our Chart Area has been defined by this lovely border and fill that we applied to it.,Now lets go ahead and select and customize another chart element within the chart.,With the chart selected, under our Layout tab,lets choose the Chart Elements menu to select the data series itself.,Notice that when I select the Sales data series, I can, in fact, format the selection,and I can change it to do something kind of cool. Notice that I can explode this pie.,I can have it be together or separate or together or separate.,So what we are going to do is set this up about 10 percent and then we will close this.,Youll notice that the pie as a whole has separated allowing me to focus on individual pieces.,If however I wish to, I can once again format my selection and rejoin the pie and then click Close.,Keep in mind you can also manually select