EXCEL 2007 Charts: Column, Bar, Pie and Line
A. Colin starrkingschool.net, Dept. That starrkingschool.netomics, Univ. OfCalif.- DavisThis January 2009 help sheet offers information on how to constructcharts graph basics column chart tower chart: Customizing Pie chart Pie Chartt: personalizing Line Chart line Chartt: personalizing Printing and also Copying Charts Resizing and Repositioning Charts the is easiest to find out chart do by hand-operated experience.CHART BASICS
To create a chartpick the data to appear to show up in the chart (with labels ifrelevant) use the Insert tab and also Charts Group and also click ~ above the relevantchart in this group.
The main species of chart supplied in analysis of starrkingschool.netomcis data are:column chart: for comparing data throughout categories Pie Chart: for showing the family member shares of categories in atotal heat Chart: for reflecting trends in a series over time Scatter Plot: for mirroring the relationship between two series(given later).
It can be helpful to first modify the data for much better presentation onthe chart. For example, because that a pie or obelisk chart we may want to orderthe data by value.Charts often immediately select chart location and/or axis or categorylabels indigenous the over data, so the is useful to choose clear brief nameswhere possible.Excel defaults usually lead to 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 actual chart) The x-axis (for charts various other than pie chart) which is called acategoryaxis for pillar or heat chart and also a value axis for a bar chart. The y-axis (for charts other than pie chart) i beg your pardon is dubbed avalueaxisfor shaft or heat chart and also a category axis for a bar chart. Legend entry (explains the symbols used in the chart) Labels because that the x-axis Labels for the y-axis.To modify an existing graph one can pick the graph (click within thechartand the border i do not care highlighted).Then select within the chart that component of the chartyou great to change and rightclick to obtain the food selection for reformatting the chart.In some situations the graph Tools team with subgroups Design, Layout and Further details are offered below.
As an instance consider categorical data top top 1997 U.S. Health and wellness CareExpenditures.
You are watching: In a clustered column chart, the names of each column are part of the ____ series
The data space in record healthexpendituresdata.csv
To develop a shaft chart native the aboveto mark the data andheadings (here columns A1:B13) select the Insert Tab and also Charts group and click on obelisk Chart pick the 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) select the Insert Tab and Charts group and click top top Pie Chart select the sstarrkingschool.netd of the 2-D Pie Charts (an exploded pie chart).This yields
The line chart is not really beneficial for categorical data together above. The line chartis finest used for numerical data that are observed end time.
We take into consideration monthly data on the full return indigenous the conventional andPoors 500 stock index (with reinvestment the dividends) native 1970 to1988.The data are in document SandP500stockpricedata.csvThe first few observations are
Here the months of 1970 space 1970 (Jan), 1970.08 (Feb), 1978.17(March), 1978.25 (April), ...
To create a heat chart from the aboveHighlight just the data for TRSP500 (not the date) andthe headings (here columns B1:B1359) select the Insert Tab and also Charts group and also click on line Chart select the first of the 2-D line Charts (a heat chart).This yields
A horiiontal axis have the right to be included byhighlight the graph In Chart devices at the top choose Layout and Axis Titles select Primary Horizontal Axis Title pick Title below Axis
A vertical axis can likewise be added, where we at some point selectRotated Axis.
See more: How Does The Phosphorus Cycle Differ From The Carbon Cycle, Difference Between Carbon And Phosphorus Cycle
PRINTING and also COPYING CHARTS
See Excel 2007: Formatting, Saving,Printing and also CopyingResults
CHANGE graph SIZE and also POSITION
To resize the chartActivate it by clicking as soon as inside the chart. Location the allude of the arrowhead on among the eight rectangularhandleslocated on the charts border and click and also drag the mouse. The chartwill change size and shape depending upon the direction of thedrag. Experiment through the resizing until you obtain an idea of just how it works.
To reposition a chartplace the point of the cursor in the chart border Click and also drag the chart to a brand-new position in the worksheet.
To remove a chart from a worksheetActivate it and also then pressthe DELETE key.
For more information on how to use Excel walk to http://starrkingschool.net/excel/excel.html