EXCEL 2007 Charts: Column, Bar, Pie and Line

A. Colin rewildtv.com, Dept. That rewildtv.comomics, Univ. OfCalif.- Davis

This January 2009 assist sheet provides information on exactly how to constructcharts graph basics obelisk chart shaft chart: Customizing Pie graph Pie Chartt: tailoring Line Chart line Chartt: tailoring Printing and also Copying Charts Resizing and Repositioning Charts that is simplest to learn chart do by hand-operated experience.CHART BASICS

To produce a chart

select the data to show up to appear in the graph (with labels ifrelevant) use the Insert tab and also Charts Group and click top top the relevantchart in this group.

The main species of chart offered in analysis of rewildtv.comomcis data are:

column chart: for comparing data across categories Pie Chart: for mirroring the loved one shares of category in atotal line Chart: for reflecting trends in a collection over time Scatter Plot: for mirroring the relationship in between two series(given later).

It can be advantageous to an initial modify the data for much better presentation onthe chart. Because that example, for a pie or obelisk chart we might want to orderthe data through value.Charts often automatically select chart location and/or axis or categorylabels native the above data, so that is advantageous to select clear short nameswhere possible.Excel defaults usually lead to a chart that is reasonable but stillneeds 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) i m sorry is called acategoryaxis for shaft or line chart and a value axis because that a bar chart. The y-axis (for charts other than pie chart) i m sorry is called avalueaxisfor pillar or line chart and a group axis for a bar chart. Legend entrance (explains the symbols provided in the chart) Labels because that the x-axis Labels for the y-axis.To edit an existing chart one can choose the graph (click within thechartand the border becomes highlighted).Then pick within the graph that component of the chartyou wish to readjust and rightclick to obtain the menu for reformatting the chart.In some situations the chart Tools group with subgroups Design, Layout and also Further details are given below.


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

You are watching: A ________ contains the actual values that are plotted on the chart

The data are in record healthexpendituresdata.csv


To create a pillar chart native the above

highlight the data andheadings (here columns A1:B13) select the Insert Tab and also Charts group and also click on shaft Chart select the very first of the 2-D pillar Charts (a clustered columnchart).This returns
Note that Excel provides the first series (Category) for the x-axis labelsand the 2nd series (Expenditures) for the y-axis values.Also note the advantage to having the original data notified indescending value of expenditures. Column CHARTS: CUSTOMIZING
The resulting tower chart is usually okay however prettierwith a betterchart title and also the legend entrance dropped. Select the Chart location by clicking Expenditures at the top ofthechart. To readjust the font (size and type) ideal click and also select fontand make appropriate changes in the Font dialog box. Readjust the surname to 1997 U.S. Health and wellness Expenditures(in $billion). To eliminate the expenditures entry in ~ the right, clicking onExpenditures then ideal click and also select delete.PIE CHARTS

To create a pie chartfrom the above

to mark the data andheadings (here columns A1:B13) choose the Insert Tab and Charts group and also click on Pie Chart select the srewildtv.comd of the 2-D Pie Charts (an exploded pie chart).This yields
The resulting pie graph lacks al the group names and also it could behelpfulto include the portion breakdown.To get all group names select 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 package in the middle.We attain
To acquire the percentage malfunction choose the key chart area by clicking in the main chart area. Right-click to acquire the following dialog box.
Click on add Data brand which gives the values of theexpenditures (not percentages). Right click in the main chart area which offers the over dialogbox with the extra entry format Data Labels. Click format Data Labels and also in the style Data labels dialogbox deselect Value and also select Percentage.
Select close and we obtain

The line chart is not really useful for categorical data together above. The line chartis ideal used for numerical data that room observed end time.

We think about monthly data ~ above the complete return from the typical andPoors 500 share index (with reinvestment the dividends) indigenous 1970 to1988.The data are in record SandP500stockpricedata.csvThe first few observations are


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

To create a heat chart indigenous the above

Highlight simply the data for TRSP500 (not the date) andthe headings (here columns B1:B1359) pick the Insert Tab and also Charts group and also click on heat Chart select the very first of the 2-D line Charts (a heat chart).This yields
The x-axes because that this chart is the heat number, no the date. Tochange tothe date: to mark the Horizintal (category) axis and right click.This returns the complying with dialog box
Choose choose Data to get the complying with dialog box
Then click Edit to gain the following dialog box
Finally to mark the selection A2:A359 (note the the heading date is notincluded here). Pick OK in the Axis brand dialog box Hit ok in the select Data source dialog boxThis yields
The displayed dates can be diminished to totality numbers highlight the Horizintal (category) axis and also right click. Choose Format Axis In the format Axis dialog box select Number readjust from general to Number; choose 0 decimal places; anduncheck usage 1000 separator

A horiiontal axis can be included by

highlight the chart In Chart tools at the top choose Layout and also Axis Titles pick Primary Horizontal Axis Title select Title listed below Axis


A vertical axis can similarly be added, wherein we eventually selectRotated Axis.

See more: What Is The Magnitude Of The Lattice Energy For Cscl? ? Can Anyone Help With Lattice Energy

We acquire



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


To resize the chart

Activate that by clicking as soon as inside the chart. Location the point of the arrow on one of the eight rectangularhandleslocated ~ above the charts border and click and drag the mouse. The chartwill change size and shape depending on the direction that thedrag. Experiment with the resizing until you get an idea of how it works.

To reposition a graph

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

To eliminate a graph from a worksheet

Activate it and also then pressthe DELETE key.

For more information on how to usage Excel walk to http://rewildtv.com/excel/excel.html