Charting in PowerPoint - Information Technology

1 Charting1 PowerPoint has an internal Charting function. It can create charts from data in most of the common chart types. Thebiggest advantage is that the data is stored internally in the PowerPoint file and can be edited and updated without havingto keep track of an external file. The disadvantage is that there is no math capability. The data has to be in it s final can also be imported from spreadsheet applications.(Note: there are capabilities for importing charts created in spreadsheet programs and even hot linking of spreadsheet dataso that if the spreadsheet changes, the chart in the PowerPoint file changes. This handout does not cover this kind of capability)The Charting utility in Microsoft Word is identical to this one in PowerPoint , and the Charting features of Excel share manyof the same are several ways to access the chartingfunctionThere are three autolayouts which include a and chart with text on the text behaves like a bulleted and chart with text on the rightChart filling the whole width of the can also be inserted on any slide using theChart command under the Insert menu or byclicking on the Insert Chart button on the note on nomenclatureAlthough Microsoft refers to this utility as Microsoft Graph, almost everywherein it and in PowerPoint they refer to these graphs as charts, so we will also usethe term chart to refer to a graph drawn from your dataWhen you first access a chart.

2 PowerPoint switches to the chartingmode. Notice that the standard andformatting toolbars have changed toreflect functions for working with data sheet window will appear, whichis already filled in. You must replacethis data with your that the first row and firstcolumn are unlabeled. They arereserved for the series and categorylabels. When you scroll around thedata sheet, these labels remain you are working with a lot of datathe datasheet can be resized like this exercise, we ll use the following data:FacultyStudentsSeeing15%65%Reading 65%15%Hearing10%10%Since we have only two categories (Students andFaculty) instead of the four in the original set (1st,2nd, 3rd & 4th quarter), we have to get rid of thelast two click and drag over the cells in question toselect them, and choose Delete from the Edit can see the chart behind the data sheet hasupdated to reflect the change, but is interpretingthose cells as having a value of zero, instead of notbeing considered at the cells are still selected, Choose Exclude Row/Columnfrom the Data menu, and then Columns from the dialogue boxwhich appears.

3 The chart will change to reflect the exclusionof the two empty columns. (You actually don t have to deletethe cells, but it s confusing to have that extra data there.)To enter the new data, click on the appropriatecell and type in the new data. As you enter newdata, the chart will update to reflect the : you can also import data from Excel, Lotus1-2-3, or SYLK files with the Import File commandunder the Edit menu, even specifying certain cellranges. Make sure the source file (or range) has theseries and category labels in the top row and lefthandcolumn, and select the upper left hand corner cellin the PowerPoint datasheet when you do the view and edit the chart, click on the close box at the rightside of the title bar of the data you need to revise the data sheet, you can choose Datasheetfrom the View menu or click on the View Datasheet icon onthe standard are some modificationsthat can be done to the datawhen viewing the data can change the format andprecision of the numbers in thecells by choosing Number underthe Format the definition of thepercentage format.

4 It does notconvert each cell to its percentageof the that you can also transposeseries and categories withcommands under the Data the datasheet closed, it can be alittle confusing to determine whetheryou are in the Charting function or inPowerPoint s normal editing are still in the Charting functionwhen the chart is outlined with theheavy, hash marked line, and thetoolbars reflect the functions associatedwith anywhere outside the chartarea will return you to the normalediting mode. The selected chart willindicated by just the handles and thetoolbars will revert to the normalediting functions. The Draw toolbarwill reappear if it was return to the Charting function,double click on the : In the Macintosh version, youhave to select Quit and return from theFile menu to return to the normal chart typeYou can change the type of chart by pulling down the menuunder the Chart type icon on the Standard toolbar.

5 A moreextensive set of choices can be accessed by choosing the ChartType command on the Chart menuThere are tabs at the top of the dialogue box to choose betweenStandard Types, each of which may provide several variationsselected by the icons to the right, or Custom Types which includeadditional specialized your own typesAfter you have modified a chart to meet your particular requirements(see following section), you can add those characteristics as a typeto the User-defined chart the Custom Types window, click on the User-defined radio buttonto access the list of user-defined types. To add the current chart asa type, click the Add button. Give the chart a Name and a descriptionwhich will appear in the description area of the dialogue :This only savesthe characteristicsof the chart,which will beapplied to thedata in thecurrent datasheetwhen you chooseit as a chart characteristics of chartsIn addition to changing its type, almost any characteristic of a chart can be modified inorder to more effectively present the are two ways to modify the characteristics of a chart, by choosing Chart Optionsfrom the Chart menu, or by selecting a component of a chart and double clicking on are several tabs across the top of the ChartOptions dialogue box, each of which will give you choicesfor that element.

6 In this example, the Gridlines have beenturned off by unchecking the appropriate check that turning them on and off is the only changeyou can make to the gridlines in this dialogue box. Youcan change other characteristics by double clicking oneof the gridlines on the chartClicking on a component of the chart will select it. Ifyou hold the cursor over the component, a flag shouldappear to identify clicking will present a dialogue box which mayhave several tabs for modifying various characteristicsof that characteristics are shared by several example, you can change the scale of the value axisby either selecting the gridlines or by selecting the valueaxis modifying data elements on a chart, you have to be careful to note whether you are selecting an entireseries, or a single element in that series.

7 The first time you click, it should select the whole series, a secondclick will select only the individual handle on each series is selectedHandles on one element aloneError BarsMost graphing programs include error bars as a separateentry on the data table. In PowerPoint , they are a propertyof an individual series or an individual element in a create error bars, click on the series or individualelement in a series, choose the Error bars tab (It may belisted as X or Y Error bars depending on the orientationof your chart), choose the type of error bars, and enterthe formatting dialogue box for any element can also beaccessed by selecting that element and choosing the topcommand on the Format menu. The wording of thecommand will change to reflect the element that has chartsThe outside border of a chart will havehandles either in the main editing mode ofPowerpoint or in the Charting and dragging on any of these handleswill resize the graph, but there will bedifferences in the way text is the main editing mode of PowerPoint , thetype will be distorted if the graph is notresized proportionately, that is, if a graph isresized horizontally to half its width withoutchanging the height, all the type will bedistorted in the same the Charting mode mode, when thesize of a chart is reduced, the type will bereduced in size, but will retain its reducing a chart in the Charting mode.

8 You can edit the font characteristics of thevarious elements of the chart to increasethe type sizes. PowerPoint may adjust therelationship of the elements to compensatefor these selecting certain elements, such as thechart area, or the legend you can rearrangethem and resize them presenting dataA chart can be placed in the animation order of a slide like anyother object. There are special settings for charts which controlthe sequence of the presentation of chart entry animation effects are more appropriate than othersfor certain types of charts. For example, using Wipe Right witha bar chart will make the the individual elements seem to growin there is some modification you cannotdo in the Charting utility or specialsequencing that you have in mind, suchas adding a comment in between chartelements, you can select Ungroup fromthe Draw menu in the normal editingmode of will receive a warning message thatungrouping will break any links with thedata.

9 After ungrouping, the chart cannotbe updated by changing the data, andthe datasheet itself is will convert all the chartelements to normal PowerPoint objectsthat can be modified with the drawingtools or regrouped to work with yoursequencing can add objects to the slide with the drawing tools (even ontop the chart, like additional labels or arrows), but the chart itselfmust go in the sequence order as one piece, and all elements ofthe chart must be revealed before adding new elements.