Excel Graphs/Charts Tutorial

<body topmargin=0 leftmargin=0 marginheight=0 marginwidth=0> <table cellpadding=0 cellspacing=0 border=0><tr> <td valign="top" colspan=2 height=110 BGCOLOR="#FFFFFF" TEXT="#080000" bgproperties="fixed" background="12bf0f21egerdp.jpg"> <div> <B><IMG SRC="12c203c0.jpg" border=0 width="32" height="60" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></B><FONT SIZE="5" COLOR="#66334C" FACE="Arial" ><B>SOCIOLOGY 212: RESEARCH METHODS</B></FONT><B>      |     </B><A HREF="index.htm" TARGET="_top" TITLE="SOCIOLOGY 212: RESEARCH METHODS"><U><B>home</B></U></A></div> <div> <A HREF="id2.htm" TARGET="_top" TITLE="Syllabus"><U>Syllabus</U></A>   |   <A HREF="id3.htm" TARGET="_top" TITLE="Research Project"><U>Research Project</U></A>   |   <A HREF="id32.htm" TARGET="_top" TITLE="Course Grading"><U>Course Grading</U></A>   |   <A HREF="id4.htm" TARGET="_top" TITLE="Exercises"><U>Exercises</U></A>   |   <A HREF="id5.htm" TARGET="_top" TITLE="Articles / Overheads "><U>Articles / Overheads </U></A>   |   <A HREF="id6.htm" TARGET="_top" TITLE="SPSS Tutorial"><U>SPSS Tutorial</U></A>   |   <B>Excel Graphs/Charts Tutorial</B>   |   <A HREF="id21.htm" TARGET="_top" TITLE="Contact Info"><U>Contact Info</U></A>   |   <A HREF="id29.htm" TARGET="_top" TITLE="Past Research Titles"><U>Past Research Titles</U></A>   |   <A HREF="id37.htm" TARGET="_top" TITLE="What to do with a Sociology Degree"><U>What to do with a Sociology Degree</U></A></div> <div> </div> </td> </tr><tr> <td valign="top" width=210 BGCOLOR="#FFFFFF" TEXT="#080000" bgproperties="fixed" background="12af2f02egerdp.jpg"> <bR> </td> <td valign="top" height=370 BGCOLOR="#FFFFFF" TEXT="#080000" bgproperties="fixed" background="12df0f03.jpg"> <div> <I><B>Excel Graphs/Charts Tutorial</B></I></div> <bR> <div> <A HREF="#information" TITLE="Excel Graphs/Charts Tutorial"><U><B><IMG BORDER="0" SRC="Symb075c00b7011800000000.png" HEIGHT="19" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">General Information</B></U></A></div> <div> <A HREF="#create_chart" TITLE="Excel Graphs/Charts Tutorial"><U><B><IMG BORDER="0" SRC="Symb075c00b7011800000000.png" HEIGHT="19" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Creating a Column / Bar Chart</B></U></A></div> <div> <A HREF="#frequency" TITLE="Excel Graphs/Charts Tutorial"><U><B><IMG BORDER="0" SRC="Symb075c00b7011800000000.png" HEIGHT="19" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Frequency</B></U></A></div> <div> <A HREF="#bivariate" TITLE="Excel Graphs/Charts Tutorial"><U><B><IMG BORDER="0" SRC="Symb075c00b7011800000000.png" HEIGHT="19" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Bivariate Chart</B></U></A></div> <div> <A HREF="#demographics" TITLE="Excel Graphs/Charts Tutorial"><U><B><IMG BORDER="0" SRC="Symb075c00b7011800000000.png" HEIGHT="19" WIDTH="24" ALIGN="bottom" HSPACE="0" VSPACE="0">Create a Demographics Chart in Word</B></U></A></div> <bR> <div> <TABLE BORDER="2" CELLPADDING="2" CELLSPACING="1" WIDTH="733" BORDERCOLORLIGHT="#C0C0C0" BORDERCOLORDARK="#808080" FRAME="BOX" RULES="ALL" HSPACE="0" VSPACE="0" > <tR> <tD VALIGN=TOP HEIGHT= 563 WIDTH="721"><div> <B>GENERAL INFORMATION</B><B> <A NAME="information"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="1" ALIGN="bottom" WIDTH="1" HSPACE="0" VSPACE="0" ></A></B></div> <bR> <bR> <div> <B>If you want to create a Chart or Graph, Excel is a fairly easy program to use.  I usually create my charts or graphs in Excel then copy and paste the final chart into my Word document.  The information found here is very basic.  If you are not familiar with Excel, this should help you create charts for your Research Project.</B></div> <bR> <bR> <div>                  1.   Open Excel</div> <div>                  2.   If a Worksheet does not appear:</div> <div>                                    a.   FILE on tool bar</div> <div>                                    b.   NEW, click OK</div> <div>                 </div> <bR> <div>                 NOTES:</div> <bR> <div>                     1.  You might want to Widen your "A" Column - this is where your labels will go.</div> <div>                                    a.   Right click on any Column "A" (whole column should highlight)</div> <div>                                    b.   go to COLUMN WIDTH - make your change (usually 20 will work)</div> <div>                                    c.   O.K.</div> <bR> <div>                    2.   To Insert a Row:</div> <div>                                    a.   Right click on a number (whole row should highlight)</div> <div>                                    b.   go to INSERT</div> <bR> <div>                    3.   You can usually Right Click any part of an excel file - including the chart when created - and </div> <div>                           a drop-down list should appear. </div> <bR> <bR> </tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 859 ><NOBR><div> <B>How to Create a Column Chart</B><B> <A NAME="create_chart"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="1" ALIGN="bottom" WIDTH="1" HSPACE="0" VSPACE="0" ></A></B></div> <bR> <div>               1.   Open a worksheet</div> <div>               2.   Type Labels and Percentages:</div> <div>                           a.  for 1 Variable Chart (common to type labels in column "A" with corresponding </div> <div>                                Percentages in Column "B" . <B> (</B><A HREF="#frequency" TITLE="Excel Graphs/Charts Tutorial"><U><B>see example</B></U></A><B>)</B></div> <div>                           b.  for Bivariate Chart (common to place Dependent Variable Labels in column "A" and</div> <div>                                place Independent Variable Labels in Column "B", "C", etc. depending on number of </div> <div>                                attributes.  <B>(</B><A HREF="#bivariate" TITLE="Excel Graphs/Charts Tutorial"><U><B>see example</B></U></A><B>)</B></div> <div>               3.   Place the cursor on the first label "strongly disagree", left click and drag down to "strongly </div> <div>                     agree" and over to include all column "B"</div> <div>               4.   Click "Graph" Icon on the tool bar</div> <div>               5.   Chart Wizard should appear:</div> <div>                           a.   Step 1:  Choose your chart / graph</div> <div>                           b.   Step 2:  Choose "Column"</div> <div>                           c.   Step 3:  Add Chart Title here or you could place above chart once you copy and paste </div> <div>                                                to Word</div> <div>                                                    i.  Y Axis = type "Percentages"</div> <div>                                                   ii.  LEGEND = Unclick "Show Legend" (Leave with Bivariate Chart)</div> <div>                                                  iii.  DATA LABELS = Click "VALUES", this places the percentages above</div> <div>                                                                                       each bar</div> <div>                           d.   Step 4:  Place chart "As Object In", then click Finish</div> <bR> <div>                6.   Chart should appear on your Worksheet.  You can Left Click (hold down) and drag the chart</div> <div>                       where you want it - mainly so it does not cover up your data.</div> <div>                7.    Right Click Y Axis - </div> <div>                           a.   FORMAT AXIS</div> <div>                           b.   SCALE</div> <div>                           c.   MAX = 100;  MAJOR UNIT = 20 (or something that will not make scale appear too</div> <div>                                               "crowded")</div> <div>               8.   Gray Background to White</div> <div>                           a.   Right Click, go to FORMAT PLOT AREA</div> <div>                           b.   Area = Automatic</div> <div>               9.   Colored Bars to Black</div> <div>                           a.   Rt. Click Bars, go to FORMAT DATA SERIES</div> <div>                           b.   Area = Black</div> <div>                           c.   Bivariate charts - if using Black & White printer, change one set to black and other to </div> <div>                                 white or BW pattern.</div> <div>             10.   Expand / Decrease Chart</div> <div>                           a.   Click Chart Border, go to one of the Black Squares, drag</div> <div>             11.   If you don't like the Gridlines, click on one and clear; Can Change Fonts as well - what ever</div> <div>                     works best for you.</div> <div>             12.   Copy / Paste into Word</div> <div>                           a.   Rt. Click in Chart area, COPY</div> <div>                           b.   Open Word, PASTE</div> <bR> </NOBR></tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 526 ><NOBR><div> <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="678" BORDERCOLORLIGHT="#C0C0C0" BORDERCOLORDARK="#808080" FRAME="VOID" RULES="NONE" HSPACE="0" VSPACE="0" > <tR> <tD VALIGN=BOTTOM COLSPAN=4 HEIGHT= 20 ><NOBR><div> <B>DISPLAY FREQUENCY INFORMATION ON A COLUMN/BAR CHART</B><B> <A NAME="frequency"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="1" ALIGN="bottom" WIDTH="1" HSPACE="0" VSPACE="0" ></A></B></div> </NOBR></tD> </tR> <tR> <tD VALIGN=BOTTOM HEIGHT= 19 WIDTH="256"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="256" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="75"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="75" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="106"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="106" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="228"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="228" HSPACE="0" VSPACE="0"></tD> </tR> <tR> <tD VALIGN=BOTTOM HEIGHT= 57 WIDTH="256"><div> CONTROL (label to know which variable you are dealing with)</div> <bR> </tD> <tD VALIGN=BOTTOM WIDTH="75"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="57" ALIGN="bottom" WIDTH="75" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="106"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="57" ALIGN="bottom" WIDTH="106" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="228"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="57" ALIGN="bottom" WIDTH="228" HSPACE="0" VSPACE="0"></tD> </tR> <tR> <tD VALIGN=BOTTOM HEIGHT= 19 ><NOBR><div>               A                                           </div> </NOBR></tD> <tD VALIGN=BOTTOM WIDTH="75"><div> B</div> </tD> <tD VALIGN=BOTTOM WIDTH="106"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="106" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="228"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="228" HSPACE="0" VSPACE="0"></tD> </tR> <tR> <tD VALIGN=BOTTOM HEIGHT= 19 WIDTH="256"><div> Strongly Disagree</div> </tD> <tD VALIGN=BOTTOM WIDTH="75"><div> 13.3</div> </tD> <tD VALIGN=BOTTOM WIDTH="106"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="106" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="228"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="228" HSPACE="0" VSPACE="0"></tD> </tR> <tR> <tD VALIGN=BOTTOM HEIGHT= 19 WIDTH="256"><div> Disagree</div> </tD> <tD VALIGN=BOTTOM WIDTH="75"><div> 23.3</div> </tD> <tD VALIGN=BOTTOM WIDTH="106"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="106" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="228"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="228" HSPACE="0" VSPACE="0"></tD> </tR> <tR> <tD VALIGN=BOTTOM HEIGHT= 19 WIDTH="256"><div> Undecided</div> </tD> <tD VALIGN=BOTTOM WIDTH="75"><div> 40</div> </tD> <tD VALIGN=BOTTOM WIDTH="106"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="106" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="228"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="228" HSPACE="0" VSPACE="0"></tD> </tR> <tR> <tD VALIGN=BOTTOM HEIGHT= 19 WIDTH="256"><div> Agree</div> </tD> <tD VALIGN=BOTTOM WIDTH="75"><div> 20</div> </tD> <tD VALIGN=BOTTOM WIDTH="106"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="106" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="228"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="228" HSPACE="0" VSPACE="0"></tD> </tR> <tR> <tD VALIGN=BOTTOM HEIGHT= 19 WIDTH="256"><div> Strongly Agree</div> </tD> <tD VALIGN=BOTTOM WIDTH="75"><div> 3.3</div> </tD> <tD VALIGN=BOTTOM WIDTH="106"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="106" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=BOTTOM WIDTH="228"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="228" HSPACE="0" VSPACE="0"></tD> </tR> </TABLE></div> <bR> <bR> <DIV ALIGN="LEFT"></DIV> <div> <IMG SRC="13dbfdf0.png" border=0 width="447" height="223" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></div> <bR> </NOBR></tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 545 ><NOBR><bR> <div> <B>DISPLAY A BIVARIATE RELATIONSHIP USING A COLUMN CHART</B><B> <A NAME="bivariate"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="1" ALIGN="bottom" WIDTH="1" HSPACE="0" VSPACE="0" ></A></B></div> <bR> <div> <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="290" BORDERCOLORLIGHT="#C0C0C0" BORDERCOLORDARK="#808080" FRAME="VOID" RULES="NONE" HSPACE="0" VSPACE="0" > <tR> <tD VALIGN=TOP HEIGHT= 38 WIDTH="150"><div> LIFESAT by GENDER</div> </tD> <tD VALIGN=TOP WIDTH="65"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="38" ALIGN="bottom" WIDTH="65" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=TOP WIDTH="65"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="38" ALIGN="bottom" WIDTH="65" HSPACE="0" VSPACE="0"></tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 19 WIDTH="150"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="19" ALIGN="bottom" WIDTH="150" HSPACE="0" VSPACE="0"></tD> <tD VALIGN=TOP WIDTH="65"><div> Male</div> </tD> <tD VALIGN=TOP><NOBR><div> Female</div> </NOBR></tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 19 WIDTH="150"><div> Strongly Agree</div> </tD> <tD VALIGN=TOP WIDTH="65"><div> 12.5</div> </tD> <tD VALIGN=TOP WIDTH="65"><div> 14.3</div> </tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 19 WIDTH="150"><div> Agree</div> </tD> <tD VALIGN=TOP WIDTH="65"><div> 0</div> </tD> <tD VALIGN=TOP WIDTH="65"><div> 0</div> </tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 19 WIDTH="150"><div> Undecided</div> </tD> <tD VALIGN=TOP WIDTH="65"><div> 43.8</div> </tD> <tD VALIGN=TOP WIDTH="65"><div> 14.3</div> </tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 19 WIDTH="150"><div> Disagree</div> </tD> <tD VALIGN=TOP WIDTH="65"><div> 18.8</div> </tD> <tD VALIGN=TOP WIDTH="65"><div> 50</div> </tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 19 ><NOBR><div> Strongly Disagree</div> </NOBR></tD> <tD VALIGN=TOP WIDTH="65"><div> 25</div> </tD> <tD VALIGN=TOP WIDTH="65"><div> 21.4</div> </tD> </tR> </TABLE></div> <bR> <bR> <DIV ALIGN="LEFT"></DIV> <div> <B><IMG SRC="13edffc0.png" border=0 width="479" height="252" ALT="Microsoft Excel Chart" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></B></div> <bR> </NOBR></tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 556 ><NOBR><bR> <bR> <div> <B>DEMOGRAPHICS TABLE </B><B> <A NAME="demographics"><IMG BORDER="0" SRC="1x1.gif" HEIGHT="1" ALIGN="bottom" WIDTH="1" HSPACE="0" VSPACE="0" ></A></B></div> <div> (Just One Example - Can be done several ways and in Word)</div> <bR> <bR> <div> <B>Table 1</B></div> <div> <B>Demographics</B></div> <div> <B>   </B></div> <div> <TABLE BORDER="2" CELLPADDING="1" CELLSPACING="1" WIDTH="601" BORDERCOLORLIGHT="#C0C0C0" BORDERCOLORDARK="#808080" FRAME="BOX" RULES="ALL" HSPACE="0" VSPACE="0" > <tR> <tD VALIGN=TOP HEIGHT= 318 ><NOBR><bR> <div> <B><U>Sex</U></B>                                           <B><U>Percent</U></B></div> <div> Male                                           50.0</div> <div> Female                                       50.0</div> <bR> <div> <B><U>Age</U></B></div> <div> 11 years                                        5.4                       </div> <div> 12 years                                      14.2</div> <div> 13 years                                      17.5</div> <div> 14 years                                      16.5</div> <div> 15 years                                      16.4</div> <div> 16 years                                      14.1</div> <div> 17 years                                      10.1</div> <div> 18 years                                        4.9</div> <div> 19 and older                                  1.1</div> <bR> </NOBR></tD> <tD VALIGN=TOP><NOBR><bR> <div> <B><U>Grade </U></B><B>                                   </B><B><U>Percent</U></B></div> <div> 6<FONT SIZE="1" COLOR="#000000" FACE="Arial" >th</FONT> grade                                     11.9</div> <div> 7<FONT SIZE="1" COLOR="#000000" FACE="Arial" >th</FONT> grade                                     16.3</div> <div> 8<FONT SIZE="1" COLOR="#000000" FACE="Arial" >th</FONT> grade                                     14.8</div> <div> 9<FONT SIZE="1" COLOR="#000000" FACE="Arial" >th</FONT> grade                                     16.2</div> <div> 10<FONT SIZE="1" COLOR="#000000" FACE="Arial" >th</FONT> grade                                   14.8</div> <div> 11<FONT SIZE="1" COLOR="#000000" FACE="Arial" >th</FONT> grade                                   14.6</div> <div> 12<FONT SIZE="1" COLOR="#000000" FACE="Arial" >th</FONT> grade                                   11.3</div> <bR> <div> <B><U>Ethnicity</U></B></div> <div> Caucasian                                   57.8</div> <div> Asian                                            3.7</div> <div> Hispanic                                       9.8</div> <div> African American                        8.4</div> <div> Native American                          3.9</div> <div> Mixed                                         16.3</div> </NOBR></tD> </tR> </TABLE></div> <div> <B>       </B></div> <div> </div> <bR> </NOBR></tD> </tR> </TABLE></div> <bR> </td> </tr></table></body>