Graphing

1
Graphing

• Group 3
• Mary King, Loren McMahon, Leslie Oden, Robert
  Haynes

2

• Open Excel document
• Type in Information
• Highlight Information that you want to graph
• Go to the Standard Toolbar and select the button
  labeled Chart Wizard.

3

• Under Chart Type select Line
• Then choose which line Chart you would like.
• Click next
• Then Click Next again

4

• Here you will see several tabs.
• Select the Titles tab and type the name of the
  Chart in the first box, the name of he X axis in
  the next box, then the name of the Y axis in the
  3rd box

5

• Click Next
• Choose as an object in Sheet 1 and click Finish

6

• First right click on the tick mark at the X-axis.
• Then Select Format Axis and the Scale Tab
• Uncheck Value (Y) axis crosses between
  categories.
• Click Ok

7

• To add a 2nd line click Chart at the top of the
  screen and select Add Data
• Highlight range of cells wanted or type in range
  of cells wanted
• Click OK

8

• Right click on the line and select Format Data
  Series
• Select the Axis Tab
• Then check the box labeled Secondary Axis
• Click Ok

9

• To change the scale right click on the Y axis
  and select format axis.
• Select the Scale Tab

10

• Type in the numbers you wish under the boxes
  labeled Min., Max., Major Unit., and Minor Unit.
• These numbers should suit the numbers in your
  Table.

11
(No Transcript)