ChartTechnique

ChartTechnique - 2. Click anywhere in the chart to select...

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

View Full Document Right Arrow Icon
Excel Charting Tip You don't need to chart existing data on a worksheet.  You can chart formulas you enter in the formula bar. In addition, you need not use the Chart Wizard  to select data to chart. See the example on the next worksheet.
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 charting tip: You don't need to chart existing data on a worksheet. You can chart formulas you enter in the formula bar. In addition, you need not use the Chart Wizard to select data to chart. Example: 10 13 20 25 50 44 1. Get an initial chart on the screen.
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2. Click anywhere in the chart to select it. Then in the formula bar, enter the =SERIES command. Parameters for this command are: 1) Series name (in double quotes), 2) first series (define the range), 3) 2nd series, 4) and an order value like 1. 3. An example command: and the result: 0.5 1 1.5 2 2.5 3 3.5 20 40 60 Column B 5 10 15 20 25 30 35 40 45 50 55 20 40 60 My Chart with Series Entered by Hand Column D...
View Full Document

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 2

ChartTechnique - 2. Click anywhere in the chart to select...

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

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