EXCEL 2007 Charts: Column, Bar, Pie and also Line
A. Colin ubraintv-jp.com, Dept. Of ubraintv-jp.comomics, Univ. OfCalif.- DavisThis January 2009 assist sheet provides information on just how to constructcharts graph basics obelisk chart column chart: Customizing Pie graph Pie Chartt: personalizing Line Chart line Chartt: customizing Printing and Copying Charts Resizing and Repositioning Charts that is simplest to discover chart do by hands-on experience.CHART BASICS
To produce a chartchoose the data to show up to show up in the graph (with labels ifrelevant) use the Insert tab and Charts Group and click on the relevantchart in this group.
The main species of chart offered in analysis of ubraintv-jp.comomcis data are:obelisk chart: for comparing data across categories Pie Chart: for reflecting the loved one shares of categories in atotal heat Chart: for showing trends in a series over time Scatter Plot: for showing the relationship in between two series(given later).
It have the right to be useful to first modify the data for much better presentation onthe chart. Because that example, for a pie or pillar chart we may want to orderthe data through value.Charts often automatically select chart title and/or axis or categorylabels native the above data, so the is useful to choose clear quick nameswhere possible.Excel defaults usually result in a chart that is reasonable but stillneeds customizing.The basic approachis to note that the chart has a number of areas:Chart title Plot Area (the yes, really chart) The x-axis (for charts other than pie chart) which is referred to as acategoryaxis for tower or heat chart and a value axis because that a bar chart. The y-axis (for charts other than pie chart) i m sorry is called avalueaxisfor column or heat chart and a classification axis because that a bar chart. Legend entry (explains the symbols provided in the chart) Labels because that the x-axis Labels because that the y-axis.To modify an existing chart one can pick the graph (click inside thechartand the border becomes highlighted).Then select within the chart that component of the chartyou great to adjust and rightclick to acquire the food selection for reformatting the chart.In some cases the chart Tools group with subgroups Design, Layout and Further details are offered below.
As an example consider categorical data top top 1997 U.S. Health and wellness CareExpenditures.
You are watching: The horizontal axis is also called the value axis
The data room in record healthexpendituresdata.csv
To create a shaft chart from the aboveto mark the data andheadings (here columns A1:B13) select the Insert Tab and also Charts group and click on shaft Chart pick the very first of the 2-D column Charts (a clustered columnchart).This returns
To produce a pie chartfrom the abovehighlight the data andheadings (here columns A1:B13) pick the Insert Tab and also Charts group and also click on Pie Chart select the 2nd of the 2-D Pie Charts (an exploded pie chart).This yields
The heat chart is no really helpful for categorical data together above. The heat chartis best used for numerical data that space observed end time.
We consider monthly data top top the full return indigenous the standard andPoors 500 stock index (with reinvestment the dividends) native 1970 to1988.The data are in file SandP500stockpricedata.csvThe first few observations are
Here the month of 1970 space 1970 (Jan), 1970.08 (Feb), 1978.17(March), 1978.25 (April), ...
To create a line chart native the overHighlight just the data because that TRSP500 (not the date) andthe headings (here columns B1:B1359) select the Insert Tab and Charts group and click on line Chart choose the very first of the 2-D heat Charts (a heat chart).This yields
A horiiontal axis deserve to be included byhighlight the chart In Chart devices at the top pick Layout and also Axis Titles choose Primary Horizontal Axis Title pick Title listed below Axis
A upright axis can an in similar way be added, wherein we eventually selectRotated Axis.
See more: I Want To Kiss You All Over Lyrics I Want To Kiss You All Over By Exile
PRINTING and also COPYING CHARTS
See Excel 2007: Formatting, Saving,Printing and also CopyingResults
CHANGE graph SIZE and also POSITION
To resize the chartActivate that by clicking when inside the chart. Place the allude of the arrow on one of the eight rectangularhandleslocated on the charts border and click and drag the mouse. The chartwill adjust size and also shape relying on the direction of thedrag. Experiment v the resizing until you get an idea of how it works.
To reposition a chartar the allude of the cursor in the chart border Click and also drag the chart to a brand-new position in the worksheet.
To remove a graph from a worksheetActivate it and then pressthe DELETE key.
For additional information on just how to use Excel go to http://ubraintv-jp.com/excel/excel.html