1 / 14

Excel 2007

Excel 2007. Graphs & Charts. TYPES OF CHARTS. Column Bar Pie Line. INSERTING CHARTS. INSERTING CHARTS. Open the Charts.xls workbook Select the cell range A3:C7 Select the Insert Tab Click on the Column Chart icon. INSERTING CHARTS. Step 1 : List of standard types Chart type box

joylyn
Download Presentation

Excel 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel 2007 Graphs & Charts

  2. TYPES OF CHARTS • Column • Bar • Pie • Line

  3. INSERTING CHARTS

  4. INSERTING CHARTS • Open the Charts.xls workbook • Select the cell range A3:C7 • Select the Insert Tab • Click on the Column Chart icon

  5. INSERTING CHARTS • Step 1: • List of standard types • Chart type box • Chart sub-type • Choose 3-D type

  6. INSERTING CHARTS New Tabs

  7. WORKING WITH CHARTS

  8. WORKING WITH CHARTS

  9. WORKING WITH CHARTS

  10. WORKING WITH CHARTS

  11. CHART AREAS Chart Area Chart Title Resize handles Plot Area Legend

  12. Using Chart Layout customizing charts

  13. CHART LAYOUT RIBBON • Chart Elements – select for formatting • Labels Group – format & options for chart/axis titles, legends, data labels, data table • Axes – position of axes & gridlines • Background – changes the colour of the plot area & 3D rotation

  14. Exercises • Open ‘charts2.xls’ • Select A3:C7 • Insert a BAR chart • Save as ‘charts3.xlsx’ • Open ‘charts4.xls’ • Select A3:C7 • Insert a LINE chart • Save as ‘charts5.xlsx’ • Open ‘charts6.xls’ • Select A3:B7 • Insert a PIE chart • Save as ‘charts7.xlsx’

More Related