EXCEL 2007 Charts: Column, Bar, Pie and Line
A. Colin chathamtownfc.net, Dept. of chathamtownfc.netomics, Univ. ofCalif.- DavisThis January 2009 help sheet gives information on how to constructcharts Chart basics Column chart Column chart: Customizing Pie Chart Pie Chartt: Customizing Line Chart Line Chartt: Customizing Printing and Copying Charts Resizing and Repositioning Charts It is easiest to learn chart making by hands-on experience.CHART BASICS
To create a chartSelect the data to appear to appear in the chart (with labels ifrelevant) Use the Insert tab and Charts Group and click on the relevantchart in this group.
The main types of chart used in analysis of chathamtownfc.netomcis data are:Column chart: for comparing data across categories Pie Chart: for showing the relative shares of categories in acomplete Line Chart: for showing trends in a series over time Scatter Plot: for showing the relationship between two series(given later).
It can be useful to first modify the data for better presentation onthe chart. For example, for a pie or column chart we may want to orderthe data by value.Charts often automatically select chart title and/or axis or categorylabels from the above data, so it is useful to choose clear short nameswhere possible.Excel defaults usually lead to a chart that is reasonable but 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 other than pie chart) which is called acategoryaxis for column or line chart and a value axis for a bar chart. The y-axis (for charts other than pie chart) which is called avalueaxisfor column or line chart and a category axis for a bar chart. Legend Entry (explains the symbols used in the chart) Labels for the x-axis Labels for the y-axis.To edit an existing chart one can select the chart (click inside thechartand the border becomes highlighted).Then select within the chart that part of the chartyou wish to change and rightclick to obtain the menu for reformatting the chart.In some cases the Chart Tools group with subgroups Design, Layout and Further details are given below.
As an example consider categorical data on 1997 U.S. Health CareExpenditures.
You are watching: In a clustered column chart, the names of each column are part of the ____ series.
The data are in file healthexpendituresdata.csv
To create a column chart from the aboveHighlight the data andheadings (here columns A1:B13) Select the Insert Tab and Charts group and click on Column Chart Select the first of the 2-D Column Charts (a clustered columnchart).This yields
To create a pie chartfrom the aboveHighlight the data andheadings (here columns A1:B13) Select the Insert Tab and Charts group and click on Pie Chart Select the schathamtownfc.netd of the 2-D Pie Charts (an exploded pie chart).This yields
The line chart is not really helpful for categorical data as above. The line chartis best used for numerical data that are observed over time.
We consider monthly data on the total return from the Standard andPoors 500 stock index (with reinvestment of dividends) from 1970 to1988.The data are in file SandP500stockpricedata.csvThe first few 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 aboveHighlight just the data for TRSP500 (not the date) andthe headings (here columns B1:B1359) Select the Insert Tab and Charts group and click on Line Chart Select the first of the 2-D Line Charts (a line chart).This yields
A horiiontal axis can be added byHighlight the chart In Chart Tools at the top select Layout and Axis Titles Select Primary Horizontal Axis Title Select Title below Axis
A vertical axis can similarly be added, where we ultimately selectRotated Axis.
See more: How To Make Your Hair Stand Up Straight, How To Make Hair Stand Up
PRINTING AND COPYING CHARTS
See Excel 2007: Formatting, Saving,Printing and CopyingResults
CHANGE CHART SIZE AND POSITION
To resize the chartActivate it by clicking once inside the chart. Place the point of the arrow on one of the eight rectangularhandleslocated on the charts border and click and drag the mouse. The chartwill change size and shape depending on the direction of thedrag. Experiment with the resizing until you get an idea of how it works.
To reposition a chartPlace the point of the cursor in the chart border Click and drag the chart to a new position in the worksheet.
To remove a chart from a worksheetActivate it and then pressthe DELETE key.
For further information on how to use Excel go to http://chathamtownfc.net/excel/excel.html