EXCEL 2007 Charts: Column, Bar, Pie and also Line
A. Colin moment-g.com, Dept. The moment-g.comomics, Univ. OfCalif.- DavisThis January 2009 help sheet provides information on how to constructcharts graph basics shaft chart column chart: Customizing Pie chart Pie Chartt: customizing Line Chart line Chartt: personalizing Printing and Copying Charts Resizing and Repositioning Charts it is simplest to learn chart making by hands-on experience.CHART BASICS
To produce a chartchoose the data to show up to show up in the graph (with brand ifrelevant) usage the Insert tab and also Charts Group and click top top the relevantchart in this group.
The main species of chart supplied in evaluation of moment-g.comomcis data are:column chart: for comparing data across categories Pie Chart: for mirroring the family member 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 advantageous to very first modify the data for better presentation onthe chart. Because that example, because that a pie or shaft chart we may want come orderthe data by value.Charts often instantly select chart location and/or axis or categorylabels native the above data, so that is beneficial to pick clear brief nameswhere possible.Excel defaults usually result in a chart that is reasonable however stillneeds customizing.The general approachis to note that the chart has a number of areas:Chart title Plot Area (the really chart) The x-axis (for charts other than pie chart) i m sorry is referred to as acategoryaxis for column or heat chart and a value axis for a bar chart. The y-axis (for charts other than pie chart) which is referred to as avalueaxisfor obelisk or line chart and a classification axis because that a bar chart. Legend entry (explains the symbols supplied in the chart) Labels for the x-axis Labels for the y-axis.To modify an existing chart one can pick the chart (click inside thechartand the border becomes highlighted).Then choose within the chart that component of the chartyou wish to change and rightclick to achieve the food selection for reformatting the chart.In some instances the chart Tools group with subgroups Design, Layout and also Further details are given below.
As an example consider categorical data top top 1997 U.S. Health CareExpenditures.
You are watching: A ________ contains the actual values that are plotted on the chart
The data are in file healthexpendituresdata.csv
To create a tower chart native the overhighlight the data andheadings (here columns A1:B13) pick the Insert Tab and Charts group and also click on tower Chart choose the very first of the 2-D shaft Charts (a clustered columnchart).This yields
To develop a pie chartfrom the overhighlight the data andheadings (here columns A1:B13) choose the Insert Tab and also Charts group and also click ~ above Pie Chart select the 2nd of the 2-D Pie Charts (an explosive pie chart).This yields
The heat chart is no really valuable for categorical data together above. The heat chartis ideal used because that numerical data that room observed over time.
We take into consideration monthly data on the total return native the standard andPoors 500 stock index (with reinvestment the dividends) native 1970 to1988.The data room in file SandP500stockpricedata.csvThe first couple of observations are
Here the months of 1970 are 1970 (Jan), 1970.08 (Feb), 1978.17(March), 1978.25 (April), ...
To create a line chart from the overHighlight just the data for TRSP500 (not the date) andthe headings (here columns B1:B1359) pick the Insert Tab and Charts group and also click on line Chart select the an initial of the 2-D line Charts (a heat chart).This yields
A horiiontal axis can be included byhighlight the graph In Chart tools at the top choose Layout and also Axis Titles pick Primary Horizontal Axis Title select Title below Axis
A vertical axis can similarly be added, whereby we ultimately selectRotated Axis.
See more: Harvest Moon Tree Of Tranquility Blue Feather ? Blue Feather
PRINTING and COPYING CHARTS
See Excel 2007: Formatting, Saving,Printing and also CopyingResults
CHANGE chart SIZE and POSITION
To resize the chartActivate the by clicking once inside the chart. Location the suggest of the arrowhead on among the eight rectangularhandleslocated top top the charts border and click and drag the mouse. The chartwill change size and also shape relying on the direction of thedrag. Experiment with the resizing until you obtain an idea of exactly how it works.
To reposition a graphar the allude of the cursor in the graph border Click and also drag the graph to a brand-new position in the worksheet.
To eliminate a chart from a worksheetActivate it and also then pressthe DELETE key.
For more information on exactly how to usage Excel walk to http://moment-g.com/excel/excel.html