EXCEL 2007 Charts: Column, Bar, Pie and also Line
A. Colin ubraintv-jp.com, Dept. Of ubraintv-jp.comomics, Univ. OfCalif.- Davis
This 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 BASICSTo produce a chart
choose 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.COLUMN CHARTS
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 above
to 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 above
highlight 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 over
Highlight 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 by
highlight 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
We acquire

PRINTING and also COPYING CHARTS
See Excel 2007: Formatting, Saving,Printing and also CopyingResults
CHANGE graph SIZE and also POSITION
To resize the chart
Activate 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 chart
ar 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 worksheet
Activate it and then pressthe DELETE key.For additional information on just how to use Excel go to http://ubraintv-jp.com/excel/excel.html