EXCEL 2007 Charts: Tower, Bar, Pie and Line
A. Colin nlinux.org, Dept. of nlinux.orgomics, Univ. ofCalif.- DavisThis January 2009 aid sheet provides information on how to constructcharts Chart basics Obelisk chart Shaft chart: Customizing Pie Chart Pie Chartt: Customizing Line Chart Line Chartt: Customizing Printing and Copying Charts Resizing and also Replacing Charts It is most basic to learn chart making by hand-operated endure.CHART BASICS
To develop a chartSelect the data to show up to show up in the chart (through labels ifrelevant) Use the Insert tab and also Charts Group and click the relevantchart in this group.
The major types of chart supplied in evaluation of nlinux.orgomcis information are:Obelisk chart: for comparing information throughout categories Pie Chart: for reflecting the family member shares of categories in atotal Line Chart: for showing patterns in a collection over time Scatter Plot: for showing the connection between two series(offered later).
It have the right to be useful to first modify the data for better presentation onthe chart. For example, for a pie or column chart we might desire to orderthe information by value.Charts frequently automatically choose chart title and/or axis or categorylabels from the above data, so it is valuable to select clear brief nameswright here feasible.Excel defaults commonly cause a chart that is reasonable but stilldemands tailoring.The basic approachis to note that the chart has actually a number of areas:Chart Title Plot Area (the actual chart) The x-axis (for charts various other than pie chart) which is dubbed acategoryaxis for column or line chart and also a worth axis for a bar chart. The y-axis (for charts various other than pie chart) which is called avalueaxisfor column or line chart and also a category axis for a bar chart. Legend Enattempt (describes the symbols supplied in the chart) Labels for the x-axis Labels for the y-axis.To modify an existing chart one have the right to select the chart (click inside thechartand the border becomes highlighted).Then choose within the chart that component of the chartyou wish to adjust and also rightclick to achieve the menu for reformatting the chart.In some situations the Chart Tools team via subteams Design, Layout and More details are provided below.
As an example consider categorical data on 1997 U.S. Health CareExpenditures.
You are watching: A pie chart ____.
The data are in file healthexpendituresinformation.csv
To produce a column chart from the overHighlight the information andheadings (right here columns A1:B13) Select the Insert Tab and also Charts team and click Tower Chart Select the initially of the 2-D Tower Charts (a clustered columnchart).This returns
To develop a pie chartfrom the aboveHighlight the information andheadings (here columns A1:B13) Select the Insert Tab and Charts team and click on Pie Chart Select the snlinux.orgd of the 2-D Pie Charts (an exploded pie chart).This yields
The line chart is not really helpful for categorical information as over. The line chartis finest supplied for numerical information that are observed over time.
We consider monthly information on the full rerotate from the Standard andPoors 500 stock index (via reinvestment of dividends) from 1970 to1988.The data are in file SandP500stockpricedata.csvThe first few monitorings 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 simply the information for TRSP500 (not the date) andthe headings (right here columns B1:B1359) Select the Insert Tab and Charts team and also click on Line Chart Select the first of the 2-D Line Charts (a line chart).This yields
A horiiontal axis have the right to be included byHighlight the chart In Chart Tools at the height pick Layout and Axis Titles Select Key Horizontal Axis Title Select Title below Axis
A vertical axis deserve to similarly be included, where we eventually selectRotated Axis.
See more: What Is The Best-Known Polytheistic Religion Is M, The Best Known Polytheistic Religion Is
PRINTING AND COPYING CHARTS
See Excel 2007: Formatting, Saving,Printing and CopyingResults
CHANGE CHART SIZE AND POSITION
To resize the chartActivate it by clicking when inside the chart. Place the suggest of the arrowhead on one of the eight rectangularhandlessituated on the charts border and click and also drag the mouse. The chartwill change size and also form depending on the direction of thedrag. Experiment through the resizing until you gain an concept of exactly how it works.
To reposition a chartPlace the point of the cursor in the chart border Click and drag the chart to a brand-new place in the worksheet.
To rerelocate a chart from a worksheetActivate it and then pressthe DELETE key.
For better information on just how to use Excel go to http://nlinux.org/excel/excel.html