EXCEL 2007 Charts: Shaft, Bar, Pie and Line

A. Colin muzic-ivan.info, Dept. of muzic-ivan.infoomics, Univ. ofCalif.- Davis

This January 2009 help sheet provides indevelopment on just how to constructcharts Chart basics Shaft chart Tower chart: Customizing Pie Chart Pie Chartt: Customizing Line Chart Line Chartt: Customizing Printing and Copying Charts Resizing and also Replacing Charts It is easiest to learn chart making by hands-on experience.CHART BASICS

To produce a chart

Select the data to appear to show up in the chart (with labels ifrelevant) Use the Insert tab and Charts Group and click on the relevantchart in this team.

The primary forms of chart used in evaluation of muzic-ivan.infoomcis information are:

Shaft chart: for comparing information throughout categories Pie Chart: for mirroring the loved one shares of categories in afull Line Chart: for mirroring patterns in a collection over time Scatter Plot: for mirroring the partnership in between two series(given later).

It have the right to be helpful to first modify the data for better presentation onthe chart. For example, for a pie or column chart we may want to orderthe information by value.Charts regularly instantly choose chart title and/or axis or categorylabels from the over data, so it is helpful to choose clear short nameswbelow feasible.Excel defaults normally bring about a chart that is reasonable however stilldemands customizing.The basic approachis to note that the chart has actually a variety of areas:

Chart Title Plot Area (the actual chart) The x-axis (for charts other than pie chart) which is dubbed acategoryaxis for column or line chart and also a value axis for a bar chart. The y-axis (for charts various other than pie chart) which is called avalueaxisfor column or line chart and a category axis for a bar chart. Legfinish Enattempt (defines the signs supplied in the chart) Labels for the x-axis Labels for the y-axis.To edit an existing chart one deserve to choose 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 obtain the food selection for reformatting the chart.In some situations the Chart Tools team via subteams Design, Layout and also Further details are given below.


As an instance think about categorical information on 1997 UNITED STATE Health CareExpenditures.

You are watching: You should use a ____ chart to compare values side by side, broken down by category.

The data are in file healthexpendituresinformation.csv


To create a column chart from the above

Highlight the data andheadings (below columns A1:B13) Select the Insert Tab and also Charts team and also click Column Chart Select the initially of the 2-D Tower Charts (a clustered columnchart).This returns
Note that Excel supplies the initially series (Category) for the x-axis labelsand the smuzic-ivan.infod series (Expenditures) for the y-axis worths.Also note the advantage to having the original information ordered indescfinishing value of expenditures. COLUMN CHARTS: CUSTOMIZING
The resulting column chart is basically okay but prettiervia a betterchart title and also the legfinish entry dropped. Select the Chart Title by clicking on Expenditures at the height ofthechart. To readjust the font (dimension and type) appropriate click and select fontand make proper transforms in the Font dialog box. Change the name to 1997 UNITED STATE Health Expenditures(in $billion). To remove the Expenditures enattempt at the appropriate, clicking onExpenditures then ideal click and also pick delete.PIE CHARTS

To develop a pie chartfrom the above

Highlight the data andheadings (right here columns A1:B13) Select the Insert Tab and Charts team and click on Pie Chart Select the smuzic-ivan.infod of the 2-D Pie Charts (an exploded pie chart).This yields
The resulting pie chart lacks al the category names and it might behelpfulto include the portion breakdvery own.To acquire all category names Select the legfinish area by clicking the legfinish. Move the legend up to the peak of the figure. At the middle of the bottom drag on the box in the middle.We obtain
To gain the percent breakdvery own Select the major chart area by clicking in the main chart location. Right-click to acquire the complying with dialog box.
Click on Add Documents Labels which gives the worths of theexpenditures (not percentages). Right click in the main chart area which offers the over dialogbox via the extra entry Layout File Labels. Click on format Data Labels and also in the Format File Labels dialogbox dechoose Value and also pick Percentage.
Select close and also we obtain

The line chart is not really helpful for categorical data as over. The line chartis best offered for numerical data that are observed over time.

We think about monthly information on the total return from the Standard andPoors 500 stock index (through reinvestment of dividends) from 1970 to1988.The information are in file SandP500stockpriceinformation.csvThe initially few monitorings are


Here the months of 1970 are 1970 (Jan), 1970.08 (Feb), 1978.17(March), 1978.25 (April), ...

To develop a line chart from the over

Highlight simply the data for TRSP500 (not the date) andthe headings (below columns B1:B1359) Select the Insert Tab and also Charts group and click on Line Chart Select the initially of the 2-D Line Charts (a line chart).This yields
The x-axes for this chart is the row number, not the day. Toadjust tothe date: Highlight the Horizintal (category) axis and appropriate click.This yields the adhering to dialog box
Choose Select File to gain the complying with dialog box
Then click Edit to get the following dialog box
Finally Highlight the array A2:A359 (note that the heading DATE is notincluded here). Select OK in the Axis Labels dialog box Hit OK in the Select Documents Source dialog boxThis yields
The shown days have the right to be reduced to whole numbers Highlight the Horizintal (category) axis and appropriate click. Select Layout Axis In the Format Axis dialog box select Number Change from general to Number; select 0 decimal places; andunexamine usage 1000 separator

A horiiontal axis deserve to be included by

Highlight the chart In Chart Tools at the optimal choose Layout and also Axis Titles Select Key Horizontal Axis Title Select Title listed below Axis


A vertical axis can similarly be included, wbelow we eventually selectRotated Axis.

See more: How To Delete Photos From Flickr Photostream ? The Help Forum: Deleting Photos From Photostream

We obtain



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


To redimension the chart

Activate it by clicking once inside the chart. Place the allude of the arrow on one of the eight rectangularhandleslocated on the charts border and click and also drag the mouse. The chartwill adjust size and form relying on the direction of thedrag. Experiment through the resizing until you acquire an principle of how it works.

To replace a chart

Place the allude of the cursor in the chart border Click and also drag the chart to a new place in the worksheet.

To remove a chart from a worksheet

Activate it and also then pressthe DELETE essential.

For additionally indevelopment on just how to usage Excel go to http://muzic-ivan.info/excel/excel.html