EXCEL 2007 Charts: Column, Bar, Pie and also Line

A. Colin moment-g.com, Dept. The moment-g.comomics, Univ. OfCalif.- Davis

This 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 chart

choose 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 over

highlight 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
Note that Excel offers the first series (Category) because that the x-axis labelsand the 2nd series (Expenditures) for the y-axis values.Also note the benefit to having the original data notified indescending value of expenditures. Tower CHARTS: CUSTOMIZING
The resulting obelisk chart is usually okay however prettierwith a betterchart title and also the legend entry dropped. Pick the Chart location by clicking Expenditures at the optimal ofthechart. To change the font (size and also type) appropriate click and also select fontand make appropriate changes in the Font dialog box. Change the name to 1997 U.S. Health and wellness Expenditures(in $billion). To get rid of the expenditure entry in ~ the right, clicking onExpenditures then right click and also select delete.PIE CHARTS

To develop a pie chartfrom the over

highlight 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 resulting pie graph lacks al the category names and it might behelpfulto include the percentage breakdown.To obtain all group names pick the legend area by clicking the legend. Move the legend as much as the height of the figure. In ~ the middle of the bottom traction on the box in the middle.We achieve
To obtain the percentage breakdown pick the key chart area by clicking in the main chart area. Right-click to acquire the complying with dialog box.
Click on add Data labels which offers the values of theexpenditures (not percentages). Right click in the main chart area which gives the above dialogbox through the extra entry layout Data Labels. Click on format Data Labels and also in the format Data labels dialogbox deselect Value and select Percentage.
Select close and also we obtain

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 over

Highlight 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
The x-axes because that this graph is the heat number, no the date. Tochange tothe date: highlight the Horizintal (category) axis and also right click.This yields the adhering to dialog box
Choose choose Data to obtain the adhering to dialog box
Then click on Edit to get the adhering to dialog box
Finally highlight the variety A2:A359 (note the the heading day is notincluded here). Select OK in the Axis brand dialog crate Hit yes in the select Data resource dialog boxThis yields
The displayed days can be reduced to whole numbers to mark the Horizintal (category) axis and right click. Pick Format Axis In the format Axis dialog box pick Number readjust from general to Number; choose 0 decimal places; anduncheck use 1000 separator

A horiiontal axis can be included by

highlight 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

We achieve



See Excel 2007: Formatting, Saving,Printing and also CopyingResults


To resize the chart

Activate 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 graph

ar 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 worksheet

Activate 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