EXCEL 2007 Charts: Column, Bar, Pie and Line
A. Colin rewildtv.com, Dept. That rewildtv.comomics, Univ. OfCalif.- DavisThis January 2009 assist sheet provides information on exactly how to constructcharts graph basics obelisk chart shaft chart: Customizing Pie graph Pie Chartt: tailoring Line Chart line Chartt: tailoring Printing and also Copying Charts Resizing and Repositioning Charts that is simplest to learn chart do by hand-operated experience.CHART BASICS
To produce a chartselect the data to show up to appear in the graph (with labels ifrelevant) use the Insert tab and also Charts Group and click top top the relevantchart in this group.
The main species of chart offered in analysis of rewildtv.comomcis data are:column chart: for comparing data across categories Pie Chart: for mirroring the loved one shares of category in atotal line Chart: for reflecting trends in a collection over time Scatter Plot: for mirroring the relationship in between two series(given later).
It can be advantageous to an initial modify the data for much better presentation onthe chart. Because that example, for a pie or obelisk chart we might want to orderthe data through value.Charts often automatically select chart location and/or axis or categorylabels native the above data, so that is advantageous to select clear short nameswhere possible.Excel defaults usually lead to a chart that is reasonable but stillneeds customizing.The basic approachis to note that the chart has actually a variety of areas:Chart title Plot Area (the actual chart) The x-axis (for charts other than pie chart) i m sorry is called acategoryaxis for shaft or line 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 pillar or line chart and a group axis for a bar chart. Legend entrance (explains the symbols provided in the chart) Labels because that the x-axis Labels for the y-axis.To edit an existing chart one can choose the graph (click within thechartand the border becomes highlighted).Then pick within the graph that component of the chartyou wish to readjust and rightclick to obtain the menu for reformatting the chart.In some situations the chart Tools group with subgroups Design, Layout and also Further details are given below.
As an instance consider categorical data ~ above 1997 U.S. Health and wellness CareExpenditures.
You are watching: A ________ contains the actual values that are plotted on the chart
The data are in record healthexpendituresdata.csv
To create a pillar chart native the abovehighlight the data andheadings (here columns A1:B13) select the Insert Tab and also Charts group and also click on shaft Chart select the very first of the 2-D pillar Charts (a clustered columnchart).This returns
To create a pie chartfrom the aboveto mark the data andheadings (here columns A1:B13) choose the Insert Tab and Charts group and also click on Pie Chart select the srewildtv.comd of the 2-D Pie Charts (an exploded pie chart).This yields
The line chart is not really useful for categorical data together above. The line chartis ideal used for numerical data that room observed end time.
We think about monthly data ~ above the complete return from the typical andPoors 500 share index (with reinvestment the dividends) indigenous 1970 to1988.The data are in record SandP500stockpricedata.csvThe first few observations are
Here the month of 1970 are 1970 (Jan), 1970.08 (Feb), 1978.17(March), 1978.25 (April), ...
To create a heat chart indigenous the aboveHighlight simply the data for TRSP500 (not the date) andthe headings (here columns B1:B1359) pick the Insert Tab and also Charts group and also click on heat Chart select the very first of the 2-D line Charts (a heat chart).This yields
A horiiontal axis can be included byhighlight the chart In Chart tools at the top choose Layout and also Axis Titles pick Primary Horizontal Axis Title select Title listed below Axis
A vertical axis can similarly be added, wherein we eventually selectRotated Axis.
See more: What Is The Magnitude Of The Lattice Energy For Cscl? ? Can Anyone Help With Lattice Energy
PRINTING and COPYING CHARTS
See Excel 2007: Formatting, Saving,Printing and also CopyingResults
CHANGE graph SIZE and also POSITION
To resize the chartActivate that by clicking as soon as inside the chart. Location the point of the arrow on one of the eight rectangularhandleslocated ~ above the charts border and click and drag the mouse. The chartwill change size and shape depending on the direction that thedrag. Experiment with the resizing until you get an idea of how it works.
To reposition a graphar the point of the cursor in the chart border Click and also drag the chart to a new position in the worksheet.
To eliminate a graph from a worksheetActivate it and also then pressthe DELETE key.
For more information on how to usage Excel walk to http://rewildtv.com/excel/excel.html