Lesson 19 charting and transmitting worksheet data
Download
1 / 17

Lesson 19: Charting and Transmitting Worksheet Data - PowerPoint PPT Presentation


  • 110 Views
  • Uploaded on

Lesson 19: Charting and Transmitting Worksheet Data. Learning Objectives. After studying this lesson, you will be able to: Create a variety of different types of charts Move and size embedded charts Modify, format, and print charts Send a worksheet or workbook via email

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

PowerPoint Slideshow about ' Lesson 19: Charting and Transmitting Worksheet Data' - lazar


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

Learning objectives
Learning Objectives

  • After studying this lesson, you will be able to:

    • Create a variety of different types of charts

    • Move and size embedded charts

    • Modify, format, and print charts

    • Send a worksheet or workbook via email

    • Import web data into a worksheet


Chart creation in excel
Chart Creation in Excel

  • Linked to the data from which they come

  • Two locations for charts:

    • Embedded in a worksheet with the data

    • On a separate worksheet

Tip! If you create a chart and then tap [F11], the chart will be placed on its own worksheet.


Source data for charts
Source Data for Charts

  • Very important! Select the correct data as the source for the chart.

The ranges A4:A8 and F4:F8 have been selected as the location of the source data for the chart


Chart types
Chart Types

  • Eleven major chart types

    • Each has many subtypes


Chart and axis titles
Chart and Axis Titles

  • Create titles for charts and their vertical/horizontal axes

Chart title

Horizontal axis title

Vertical axis title


Chart tools
Chart Tools

  • Chart Tools appear as contextual tabs of the Ribbon when a chart is selected


Embedded charts moving sizing
Embedded Charts: Moving & Sizing

  • Embedded charts can be moved around the worksheet in which they are embedded

  • Can be resized, too

Click and drag with a four-way arrow to move the chart to a new location

When you see a double-arrow, click and drag to resize the chart


Line charts
Line Charts

  • Compare trends over a period of time


Pie charts
Pie Charts

  • Graphically display the parts of a whole


Modifying existing charts
Modifying Existing Charts

  • Modify any chart object after the chart has been created:

    • Size, font, color

    • Placement of title

    • Number formatting

    • Background color

    • Add/remove chart elements such as legends

    • You can even move an embedded chart to a separate worksheet and vice versa…


Formatting chart elements
Formatting Chart Elements

  • Must first select an element before making changes

  • Changes can be made on the Chart Tools tabs or with the formatting commands on the Home tab


Chart styles
Chart Styles

  • Chart styles will be displayed on the Design tab of the Ribbon

  • Based on the type of chart selected


Previewing and printing charts
Previewing and Printing Charts

  • Preview how charts will appear when printed

  • Viewed on the Print tab of Backstage view

    • Use same procedures as you would for printing any worksheet

Tip! Color fills and borders may not provide good contrast in charts printed in grayscale. Consider using shades of gray or patterns.

Note! A print previewed chart will display in black and white or in color, depending on the type of printer selected.


Emailing workbooks and worksheets
Emailing Workbooks and Worksheets

  • Attach workbook to an email

  • Singe worksheet in the body of an email


Using a web query to import data
Using a Web Query to Import Data

  • Use the From Web command

  • Choose how often to refresh data

You must select the table data from a web page to include in a web query



ad