06 ExcelCharts

06 ExcelCharts - Excel Charts CEE 3804: Computer Apps for...

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

View Full Document Right Arrow Icon
Excel Charts CEE 3804: Computer Apps for Civil and Environmental Engineers
Background image of page 1

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

View Full DocumentRight Arrow Icon
CEE 3804 - Rojiani 2 1. Topics to be Covered z Creating and formatting charts z Advanced charting techniques
Background image of page 2
CEE 3804 - Rojiani 3 1. Creating Charts a. Chart Basics z Chart terminology: z Background z Category and Category axis z Data marker z Data series z Data value/point z Legend z Plot area z Title z Value axis $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 1 3 5 7 9 11 13 15 17 19 Year Expenses Principal Interes t
Background image of page 3

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

View Full DocumentRight Arrow Icon
CEE 3804 - Rojiani 4 1. Creating Charts b. Chart Creation Overview z When Excel creates a chart: z it examines both the shape and contents of the range assumes more categories than data series z more rows than columns: row as category z more columns than rows: column as category assumes labels for categories z more columns than rows: top row as category labels z more rows than columns: left column as category labels z Creating a chart: z Default chart tool, ChartWizard, or copy a chart
Background image of page 4
CEE 3804 - Rojiani 5 1. Creating Charts c. Charts Options and Types z Two options: z Embedded charts: sits on top of worksheet z Separate chart sheet: on a separate worksheet z Many chart types: z Standard types z Custom types
Background image of page 5

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

View Full DocumentRight Arrow Icon
CEE 3804 - Rojiani 6 1. Creating Charts d. Creating an Embedded Chart z The Default Chart Tool: z select range and click on the Default Chart tool z The ChartWizard: z Select range and click on the ChartWizard z Insert/Chart z Copying from a Chart Sheet: z Activate chart sheet by clicking on background z Copy and paste in the worksheet
Background image of page 6
CEE 3804 - Rojiani 7 1. Creating Charts e. Creating a Separate Chart z ChartWizard: z Select range z Step 4 of the four steps indicate that chart to be
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.

This note was uploaded on 11/14/2008 for the course CEE 3804 taught by Professor Aatrani during the Fall '07 term at Virginia Tech.

Page1 / 22

06 ExcelCharts - Excel Charts CEE 3804: Computer Apps for...

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