creating excel graph - laney.edu · arial chart options legend data labels ch12 sheetl ready start...

14
Creating Excel Graph

Upload: others

Post on 28-Jul-2020

7 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Creating Excel Graph

Page 2: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Enter the data with X-axis values left of Y-axis values

Page 3: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Select data set

Page 4: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Insert Chart

Page 5: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Select XY (scatter)

Page 6: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Enter title and axes labels

Page 7: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Deselect “Major Gridlines”

Page 8: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Deselect “Show Legend”

Page 9: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

After finishing chart options, right click on line, click on “Add Trendline”

Page 10: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Under options, choose to display equation and forecast backwards number of units equal to lowest X value

Page 11: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Expand chart window by dragging window up and down

Page 12: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Right click on inside of chart

Page 13: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Select “None” for area shading

Page 14: Creating Excel Graph - laney.edu · Arial Chart Options Legend Data Labels ch12 Sheetl Ready start -77 Sheet2 Sheeta William Trego - Ou... Chart Wizard - Chart title: Step 3 of 4

Print chart