1 / 14

Excel Working with Charts and Graphics

Excel Working with Charts and Graphics. Microsoft Office 2010 Fundamentals. Introduction. Use buttons in the Illustrations, Charts, and Sparklines groups on the Insert tab to insert various types of illustrations, charts, and sparklines. 2. 2. Understanding Charts. Common chart types.

lalasa
Download Presentation

Excel Working with Charts and Graphics

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 Working with Charts and Graphics Microsoft Office 2010 Fundamentals

  2. Introduction • Use buttons in the Illustrations, Charts, and Sparklines groups on the Insert tab to insert various types of illustrations, charts, and sparklines. 2 2

  3. Understanding Charts • Common chart types

  4. Understanding Charts (continued) • Charts are made up of different elements. 4 4

  5. Creating Charts • Select a data source, then choose a type of chart. 5 5

  6. Modifying Charts • Changing Chart Design: • The Chart Tools Design tab includes commands for changing the chart type, applying a quick layout, changing the chart’s style, and moving the chart. 6 6

  7. Modifying Charts (continued) • Moving and Sizing Charts: • Move a chart to a separate worksheet using the Move Chart command to open the Move Chart dialog box. 7 7

  8. Modifying Charts (continued) • Moving and Sizing Charts: • Move a chart within a worksheet by clicking and dragging. Resize the chart by dragging a sizing handle. 8 8

  9. Modifying Charts (continued) • Modifying Chart Elements: • Modify chart elements using the Chart Tools Layout tab. 9 9

  10. Modifying Charts (continued) • Formatting Chart Elements: • Format chart elements using the Chart Tools Format tab or the Format dialog box. 10 10

  11. Creating and Customizing Sparklines • Sparklines are miniature charts that are embedded in the background of a single cell 11 11

  12. Creating and Customizing Sparklines (continued) • You can use the buttons on the Sparkline Tools Design tab to customize sparklines. 12 12

  13. Inserting and Modifying Illustrations • The commands to insert illustrations such as pictures, clip art, shapes, screenshots, and SmartArt are located on the Insert tab on the Ribbon, in the Illustrations group. 13 13

  14. Inserting and Modifying Illustrations (continued) • Picturesare digital photographs or images, stored on your computer or network. • Clip art is a collection of predesigned artwork such as drawings or images. • Drawing objects are shapes, curves, and lines that you create. A screenshot is a picture of a computer screen or part of a screen • A SmartArt graphic is a predesigned diagram made up of shapes containing text that illustrates a concept or idea. A screenshot is a picture of a computer screen or part of a screen • A SmartArt graphic is a predesigned diagram made up of shapes containing text that illustrates a concept or idea. 14 14

More Related