EXCEL 2007 Charts: Column, Bar, Pie and Line

A. Colin starrkingschool.net, Dept. That starrkingschool.netomics, Univ. OfCalif.- Davis

This January 2009 help sheet offers information on how to constructcharts graph basics column chart tower chart: Customizing Pie chart Pie Chartt: personalizing Line Chart line Chartt: personalizing Printing and also Copying Charts Resizing and Repositioning Charts the is easiest to find out chart do by hand-operated experience.CHART BASICS

To create a chart

pick the data to appear to show up in the chart (with labels ifrelevant) use the Insert tab and also Charts Group and also click ~ above the relevantchart in this group.

The main species of chart supplied in analysis of starrkingschool.netomcis data are:

column chart: for comparing data throughout categories Pie Chart: for showing the family member shares of categories in atotal heat Chart: for reflecting trends in a series over time Scatter Plot: for mirroring the relationship between two series(given later).

It can be helpful to first modify the data for much better presentation onthe chart. For example, because that a pie or obelisk chart we may want to orderthe data by value.Charts often immediately select chart location and/or axis or categorylabels indigenous the over data, so the is useful to choose clear brief nameswhere possible.Excel defaults usually lead to 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 actual chart) The x-axis (for charts various other than pie chart) which is called acategoryaxis for pillar or heat chart and also a value axis for a bar chart. The y-axis (for charts other than pie chart) i beg your pardon is dubbed avalueaxisfor shaft or heat chart and also a category axis for a bar chart. Legend entry (explains the symbols used in the chart) Labels because that the x-axis Labels for the y-axis.To modify an existing graph one can pick the graph (click within thechartand the border i do not care highlighted).Then select within the chart that component of the chartyou great to change and rightclick to obtain the food selection for reformatting the chart.In some situations the graph Tools team with subgroups Design, Layout and Further details are offered below.


As an instance consider categorical data top top 1997 U.S. Health and wellness CareExpenditures.

You are watching: In a clustered column chart, the names of each column are part of the ____ series

The data space in record healthexpendituresdata.csv


To develop a shaft chart native the above

to mark the data andheadings (here columns A1:B13) select the Insert Tab and also Charts group and click on obelisk Chart pick the first of the 2-D pillar Charts (a clustered columnchart).This returns
Note the Excel supplies the first series (Category) because that the x-axis labelsand the sstarrkingschool.netd collection (Expenditures) because that the y-axis values.Also note the advantage to having the original data notified indescending worth of expenditures. Tower CHARTS: CUSTOMIZING
The resulting column chart is basically okay yet prettierwith a betterchart title and also the legend entrance dropped. Choose the Chart location by clicking on Expenditures in ~ the top ofthechart. To readjust the font (size and also type) ideal click and also select fontand make suitable changes in the Font dialog box. Readjust the name to 1997 U.S. Health Expenditures(in $billion). To eliminate the expenditure entry in ~ the right, click onExpenditures then right click and select delete.PIE CHARTS

To create a pie chartfrom the above

to mark the data andheadings (here columns A1:B13) select the Insert Tab and Charts group and click top top Pie Chart select the sstarrkingschool.netd of the 2-D Pie Charts (an exploded pie chart).This yields
The result pie chart lacks al the group names and also it might behelpfulto incorporate the portion breakdown.To acquire all classification names pick the legend area by clicking on the legend. Move the legend up to the optimal of the figure. In ~ the middle of the bottom traction on the box in the middle.We achieve
To obtain the percentage failure choose the key chart area by click in the key chart area. Right-click to obtain the complying with dialog box.
Click on add Data labels which offers the values of theexpenditures (not percentages). Appropriate click in the main chart area which offers the over dialogbox through the extra entry style Data Labels. Click format Data Labels and in the layout Data labels dialogbox deselect Value and also select Percentage.
Select close and we obtain

The line chart is not really beneficial for categorical data together above. The line chartis finest used for numerical data that are observed end time.

We take into consideration monthly data on the full return indigenous the conventional andPoors 500 stock index (with reinvestment the dividends) native 1970 to1988.The data are in document SandP500stockpricedata.csvThe first few observations are


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

To create a heat chart from the above

Highlight just the data for TRSP500 (not the date) andthe headings (here columns B1:B1359) select the Insert Tab and also Charts group and also click on line Chart select the first of the 2-D line Charts (a heat chart).This yields
The x-axes because that this chart is the row number, no the date. Tochange tothe date: to mark the Horizintal (category) axis and right click.This yields the adhering to dialog box
Choose select Data to gain the following dialog box
Then click Edit to get the following dialog box
Finally highlight the selection A2:A359 (note that the heading day is notincluded here). Select OK in the Axis labels dialog crate Hit yes in the pick Data resource dialog boxThis yields
The displayed dates can be reduced to whole numbers highlight the Horizintal (category) axis and right click. Select Format Axis In the format Axis dialog box select Number readjust from basic to Number; pick 0 decimal places; anduncheck usage 1000 separator

A horiiontal axis have the right to be included by

highlight the graph In Chart devices at the top choose Layout and Axis Titles select Primary Horizontal Axis Title pick Title below Axis


A vertical axis can likewise be added, where we at some point selectRotated Axis.

See more: How Does The Phosphorus Cycle Differ From The Carbon Cycle, Difference Between Carbon And Phosphorus Cycle

We acquire



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


To resize the chart

Activate it by clicking as soon as inside the chart. Location the allude of the arrowhead on among the eight rectangularhandleslocated on the charts border and click and also drag the mouse. The chartwill change size and shape depending upon the direction of thedrag. Experiment through the resizing until you obtain an idea of just how it works.

To reposition a chart

place the point of the cursor in the chart border Click and also drag the chart to a brand-new position in the worksheet.

To remove a chart from a worksheet

Activate it and also then pressthe DELETE key.

For more information on how to use Excel walk to http://starrkingschool.net/excel/excel.html