Microsoft Excel Charts Graphs Excel Charts Graphs Fran Kovach

Microsoft Excel Charts & Graphs 2007 Excel Charts & Graphs 2007 Fran Kovach fkovach@siumed.edu Coley Cowan ccowan@siumed.edu Department of Information & Communication Sciences Charts or graphs used interchangeably Chart type Area Bar Column Line Pie XY (Scatter) When used Changes over time Comparison Changes and compares Trends and projections Size of parts to the whole Values in a series Create a chart by typing the information. Select A2-E7 Click the Insert ribbon Choose column SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Design ribbon shows the column chart Choose Move Chart Move Chart choose New Sheet Click OK Chart display Design ribbon choose chart styles SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Design ribbon Choose chart layouts Design ribbon choose Switch Row/ Column Design ribbon Choose Change Chart Type SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Display as a pie chart Change chart type to line Select data source Choose A2 – F7 Click OK SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Click Sheet1 to return to the worksheet Type in values for May Return to Chart1 see values for May SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Layout ribbon choose Text Box Click and drag for text box Type in text and move anywhere Layout ribbon choose Chart Title Format options for the Chart Title Layout ribbon choose Horizontal or Vertical Axis Titles SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Type in Horizontal and Vertical Axis Title Layout ribbon choose Legend Choose None or revise placement Layout ribbon choose data labels Choose None or Place data values SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Layout ribbon choose Data Table Data Table added below chart Layout ribbon choose Axes show None or horizontal or vertical Layout ribbon Gridline choose none or horizontal or vertical gridlines SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Layout ribbon choose Plot Area Layout ribbon choose Linear trendline Choose None to remove the trendline Choose More Trendline Options to change line color or style Change Line color Change line style SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Layout ribbon choose Error Bars Standard Error Bars show Standard error Choose More Error Bar Options to Customize SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Office button choose Print Print Preview Choose Page Setup to adjust Page Margins Header Footer and Other Page Setup Margins adjustments Page Setup Choose Header/Footer Click Custom Header Type Header SIU School of Medicine Department of Information and Communication Sciences Microsoft Excel Charts & Graphs 2007 Page Setup choose Header/Footer Custom Footer Type 1 of 1 This numbers the pages 1 of 2, 2 of 2 Click drag over press delete to remove Save Choose Office button Save As Name Save as type .xlsx or other file type SIU School of Medicine Department of Information and Communication Sciences