EXCEL 2007 Charts: Tower, Bar, Pie and Line

A. Colin nlinux.org, Dept. of nlinux.orgomics, Univ. ofCalif.- Davis

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

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

Highlight 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
Keep in mind that Excel provides the initially series (Category) for the x-axis labelsand the snlinux.orgd series (Expenditures) for the y-axis values.Also note the advantage to having actually the original data ordered indescending value of expenditures. COLUMN CHARTS: CUSTOMIZING
The resulting column chart is basically okay however prettierwith a betterchart title and the legend enattempt dropped. Select the Chart Title by clicking Expenditures at the peak ofthechart. To change the font (dimension and type) ideal click and also select fontand make appropriate alters in the Font dialog box. Change the name to 1997 U.S. Health Expenditures(in $billion). To eliminate the Expenditures entry at the best, clicking onExpenditures then appropriate click and also select delete.PIE CHARTS

To develop a pie chartfrom the above

Highlight 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 resulting pie chart lacks al the category names and it could behelpfulto incorporate the percent breakdvery own.To gain all category names Select the legend location by clicking the legend. Move the legend approximately the optimal of the figure. At the middle of the bottom drag on the box in the middle.We acquire
To acquire the portion breakdown Select the primary chart location by clicking in the main chart location. Right-click to get the following dialog box.
Click on Add Documents Labels which gives the values of theexpenditures (not percentages). Right click in the primary chart area which offers the above dialogbox via the extra enattempt Layout Documents Labels. Click on format Documents Labels and also in the Style Data Labels dialogbox dechoose Value and select Percentage.
Select cshed and also we obtain

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 over

Highlight 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
The x-axes for this chart is the row number, not the date. Tochange tothe date: Highlight the Horizintal (category) axis and right click.This returns the adhering to dialog box
Choose Select File to obtain the complying with dialog box
Then click Edit to gain the following dialog box
Finally Highlight the range A2:A359 (note that the heading DATE is notincluded here). Select OK in the Axis Labels dialog box Hit OK in the Select Data Source dialog boxThis yields
The presented dates have the right to be lessened to whole numbers Highlight the Horizintal (category) axis and appropriate click. Select Format Axis In the Layout Axis dialog box choose Number Change from general to Number; choose 0 decimal places; andunexamine usage 1000 separator

A horiiontal axis have the right to be included by

Highlight 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

We attain



See Excel 2007: Formatting, Saving,Printing and CopyingResults


To resize the chart

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

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

Activate it and then pressthe DELETE key.

For better information on just how to use Excel go to http://nlinux.org/excel/excel.html