1 / 18

Creating Charts

Creating Charts. Chapter 7. Charts . Chart Visual representation of worksheet data Enhance and simplify the understanding of numerical data in a worksheet because the relationship is illustrated Data series The column with numerical data Series name The label for the data series

savea
Download Presentation

Creating 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. Creating Charts Chapter 7

  2. Charts • Chart • Visual representation of worksheet data • Enhance and simplify the understanding of numerical data in a worksheet because the relationship is illustrated • Data series • The column with numerical data • Series name • The label for the data series • Categories • The division of data within a series • Category Labels • Text in cells adjacent to the data series

  3. Chart Objects • Chart Title • Describes what is charted • Legend • Corresponds to the category labels • Data labels • Identify each value in the data series • Plot area • Part of the chart that displays data • Chart area • Entire chart and all of its elements

  4. Creating Pie Charts • Pie Charts • Best for charting data this is a percentage of a whole • Includes only one series of data • Each value from the series is represented as a slice • To create • Select the data range to be charted • Insert → Pie → then choose the type of pie chart

  5. Practice: Continents • Complete Part 1 of 2

  6. Moving, Sizing, and Deleting Charts • Charts may need to be moved to display data better • Click and drag the chart border • Home → Cut • Design → Move Chart

  7. Printing a Chart • A chart that is an object in worksheet is printed when the worksheet is printed • File → Print • View → Page Layout to determine if the chart will fit completely on a page before printing • To print only a chart • Select the chart and File → Print

  8. Practice: Continents • Complete Continents – Part 2 of 2

  9. Copying a Chart into a Word Document • Charts are often included in reports and other business documents to support and simplify the understanding of the text. • To paste from Excel into a Word document • Select the chart • Home → Copy • Display the Word document • Place insertion point where the chart is to appear • Home → Paste • Use the Paste Options button to display a list of options for the pasted chart

  10. Creating Bar and Line Charts • Bar charts • Useful for comparing the differences between values • Can include several series of data • Each bar representing a value • Bars can be vertical or horizontal • Vertical – column chart • Horizontal – bar chart • Contain the following objects • Chart title – describes what is charted • Axes title – describe the data • Legend – corresponds to the series names • Vertical or value axis – contains values • Horizontal or category axis – contains category labels • Horizontal axis labels – calculated by Excel based on the maximum value in the data • Major gridlines – mark the major intervals on an axis

  11. Creating Bar and Line Charts • Line Chart • Can include several series of data with each line representing a series • Each value in a series is a point on the line • Useful for displaying the differences of data over time

  12. Practice: Temperature • Complete Temperature – Part 1 of 2

  13. Chart Design • Chart Design • Refers to • Chart type (bar, line, pie, etc.) • Data • Basic chart style • Layout • Each chart type has several subtypes

  14. Modifying a Chart Layout • Chart Layout • Placement of titles, legends and labels • Change using the Layout tab

  15. Formatting a Chart • If a chart is to be used in a document or report, format it to complement the formatting used in the document or report. • Page Layout → Themes • Shape Styles on the Format tab to change the border and color of a chart

  16. Practice: Temperature • Complete Temperature – Part 2 of 2

  17. Sparklines • Sparklines • Mini-charts that can be inserted in a cell • To insert • Select the range of cells that the sparklines are to appear • Select the appropriate type of sparkline from the Insert tab

  18. Practice: Sales Quota • Complete Sales Quota

More Related