1 / 9

charts

Excel 3. charts. Charts. Graphical representation of data contained in a worksheet Types of charts Column – show relationship among categories of data Line – Shows trends over time Pie – shows relationship of part to a whole Scatter – Shows relationship between two categories.

noah
Download Presentation

charts

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 3 charts

  2. Charts • Graphical representation of data contained in a worksheet • Types of charts • Column – show relationship among categories of data • Line –Shows trends over time • Pie – shows relationship of part to a whole • Scatter – Shows relationship between two categories

  3. Creating a Chart • Select the data • Be sure to select data in the correct order • Use the control key to select data in non-adjacent ranges • Choose the Insert Tab • Choose chart type

  4. Formatting the chart • Right click on the chart area • Resizing – click sizing handles in corner and drag • Moving – click on the white area of the chart and drag to a new location • Copy – Right click on the chard area > copy

  5. Chart Objects • To change the appearance of anything in a chart • Right click • Double click

  6. Non-Adjacent Cells • Selecting non-adjacent cells • Select the first range • Hold down the control key > select the next range

  7. Stuff to know about charts • Pie charts can only show 1 range • Title – Chart Layout Tab > Chart title • Sub-Title – Double click after the title, press enter and begin typing • Axes • X • Y

  8. More Stuff to know • Gridlines • Lines in chart that can be turned on or off to make the chart easier to read • Legend • A list that identifies colors and patterns within a chart

  9. Excel 3 charts

More Related