Lecture21_Excel4

Lecture21_Excel4 - Topics List: Spreadsheets Lecture 4...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Topics List: Spreadsheets Lecture 4 Microsoft Excel Charts
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Excel so far… Columns, rows, cells Entering and Editing Data Formatting Tips Excel Functions Sorting Data
Background image of page 2
Usefulness of Charts
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Excel Charts Charts allow you to present data entered into the worksheet in a visual format using a variety of graph types. Before you can make a chart you must first enter data into a worksheet. Enter the data into the worksheet and highlight all the cells that will be included in the chart including headers
Background image of page 4
Excel Charts In the Insert menu click on Chart to start the chart wizard The Chart Wizard brings you through the process of creating a chart by displaying a series of dialog boxes.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Excel Charts: Step 1 Chart Type – This is the first chart wizard box. Choose the Chart type and the Chart subtype if necessary. Click Next .
Background image of page 6
Excel Charts Chart Types. Microsoft Excel offers a wide selection of chart types and sub types, to help you use your data to get your point across. There are 14 standard chart types, each with several subtypes. Excel also offers twenty built-in custom types, many of which are called "Combination Charts," because they combine different types in the same chart. The default chart type (a Clustered Column chart,
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 16

Lecture21_Excel4 - Topics List: Spreadsheets Lecture 4...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online