microsoft excel 2010 illustrated n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Excel 2010- Illustrated PowerPoint Presentation
Download Presentation
Microsoft Excel 2010- Illustrated

Loading in 2 Seconds...

play fullscreen
1 / 31

Microsoft Excel 2010- Illustrated - PowerPoint PPT Presentation


  • 178 Views
  • Uploaded on

Microsoft Excel 2010- Illustrated. Unit D: Working with Charts. Objectives. Plan a chart Create a chart Move and resize a chart Change the chart design. Objectives. Change the chart layout Format a chart Annotate and draw on a chart Create a pie chart. Planning a Chart.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

Microsoft Excel 2010- Illustrated


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
    Presentation Transcript
    1. Microsoft Excel 2010- Illustrated Unit D: Working with Charts

    2. Objectives • Plan a chart • Create a chart • Move and resize a chart • Change the chart design Microsoft Office 2010-Illustrated

    3. Objectives • Change the chart layout • Format a chart • Annotate and draw on a chart • Create a pie chart Microsoft Office 2010-Illustrated

    4. Planning a Chart • Chart planning guidelines • Determine the purpose of the chart • Identify the data relationships you want to communicate graphically • Determine results you want to see • Decide which chart type is most appropriate Microsoft Office 2010-Illustrated

    5. Planning a Chart • Chart planning guidelines • Identify the worksheet data you want the chart to illustrate • Understand the elements of a chart Microsoft Office 2010-Illustrated

    6. Planning a Chart • Chart elements • The horizontal axis (x-axis) is also called the category axis • The vertical axis (y-axis) is also called the value axis • The z-axis is present in 3-D charts Microsoft Office 2010-Illustrated

    7. Planning a Chart • Chart elements • Area inside the horizontal and vertical axes is called the plot area • The scale of measure on the y-axis is identified by tick marks • A legend makes it easy to identify each data series Microsoft Office 2010-Illustrated

    8. Planning a Chart • Chart elements (cont.) • A data point is the value in a cell you select for your chart • A data marker visually represents each data point in the chart • A group of related data points is a data series Microsoft Office 2010-Illustrated

    9. Planning a Chart Chart elements Page 83-84 Tick marks Plot area Gridline Legend Vertical axis Data marker Data series Horizontal axis Microsoft Office 2010-Illustrated

    10. Planning a Chart Common chart types Page 81 Table D-1 Microsoft Office 2010-Illustrated

    11. Creating a Chart • To create a chart: • Select a range of data • Use buttons on the Insert tab of the Ribbon to create and modify a chart Microsoft Office 2010-Illustrated

    12. Creating a Chart • Sizing handles, the small series of dots at the corners and sides of the chart’s border, indicate that the chart is selected Microsoft Office 2010-Illustrated

    13. Creating a Chart • An embedded chart is one that is inserted directly in the current worksheet • A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data Microsoft Office 2010-Illustrated

    14. Creating a Chart Column chart gallery Page 83 Figure D-3 Clustered Column chart type Column chart types Microsoft Office 2010-Illustrated

    15. Moving and Resizing a Chart • An object is an independent element on a worksheet • Moving a chart object does not affect formulas or data • Resize a chart by dragging its sizing handles; • Move a chart by dragging the chart itself Microsoft Office 2010-Illustrated

    16. Moving and Resizing a Chart Moved and resized chart Let me show you….. Right-middle sizing handle Microsoft Office 2010-Illustrated

    17. Changing the Chart Design • Changing data values in the worksheet automatically updates the chart • Chart Tools tabs can be used to make specific changes in a chart Microsoft Office 2010-Illustrated

    18. Changing the Chart Design • Using the Chart Tools Design tab, you can: • Change the chart type • Modify the data range and configuration • Change the layout of objects • Choose from coordinating color schemes • Move the location of the chart Microsoft Office 2010-Illustrated

    19. Changing the Chart Design Change Chart Type dialog box Currently selected chart type Chart type categories Microsoft Office 2010-Illustrated

    20. Changing the Chart Layout • Chart Tools Layout tab makes it easy to create and modify individual chart objects • Using the Chart Tools Layout tab, you can: • Add shapes and text to a chart • Add and modify labels • Change the display of axes Microsoft Office 2010-Illustrated

    21. Changing the Chart Layout • Using the Chart Tools Layout tab, you can (cont.): • Modify the fill behind the plot area • Eliminate or change the look of gridlines • Create titles for the horizontal and vertical axes • Add graphics or background color Microsoft Office 2010-Illustrated

    22. Changing the Chart Layout Page 89 Figure D-13 Axes titles added to chart Chart title Vertical axis title Horizontal axis labels Horizontal axis title Vertical axis labels Microsoft Office 2010-Illustrated

    23. Formatting a Chart • Chart Tools Format tab can be used to make formatting enhancements • Change colors in a specific data series • Apply a style to a series using the Shape Styles group • WordArt, which lets you create curved or stylized text, can be created using the WordArt Styles group Microsoft Office 2010-Illustrated

    24. Formatting a Chart Live Preview of new style applied to data series Style hovered over Live Preview of hovered style Microsoft Office 2010-Illustrated

    25. Annotating and Drawing on a Chart • A text annotation is a label that you add to a chart to further describe data • You can add shapes such as arrows and boxes to a chart • Lines and arrows can be used to point out exact locations you want to emphasize Microsoft Office 2010-Illustrated

    26. Annotating and Drawing on a Chart Let’s look at Page 93 Text annotation and arrow shape add to chart Text annotation Microsoft Office 2010-Illustrated

    27. Create a Pie Chart • You can create multiple charts based on the same worksheet data • Different chart types can be better at emphasizing different parts of the data • In a pie chart, emphasize a data point by exploding, or pulling that slice away from the pie chart Microsoft Office 2010-Illustrated

    28. Create a Pie Chart • Backstage view can be used to preview, change settings and print • In landscape orientation, the text runs the long way on the page Microsoft Office 2010-Illustrated

    29. Create a Pie Chart Exploded pie slice Preview in Backstage view Fit on One Page setting Microsoft Office 2010-Illustrated

    30. Summary • Plan a chart • Create a chart • Move and resize a chart • Change the chart design Microsoft Office 2010-Illustrated

    31. Summary • Change the chart layout • Format a chart • Annotate and draw on a chart • Create a pie chart Microsoft Office 2010-Illustrated