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

A. Colin ubraintv-jp.com, Dept. Of ubraintv-jp.comomics, Univ. OfCalif.- Davis

This January 2009 assist sheet provides information on just how to constructcharts graph basics obelisk chart column chart: Customizing Pie graph Pie Chartt: personalizing Line Chart line Chartt: customizing Printing and Copying Charts Resizing and Repositioning Charts that is simplest to discover chart do by hands-on experience.CHART BASICS

To produce a chart

choose the data to show up to show up in the graph (with labels ifrelevant) use the Insert tab and Charts Group and click on the relevantchart in this group.

The main species of chart offered in analysis of ubraintv-jp.comomcis data are:

obelisk chart: for comparing data across categories Pie Chart: for reflecting the loved one 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 useful to first modify the data for much better presentation onthe chart. Because that example, for a pie or pillar chart we may want to orderthe data through value.Charts often automatically select chart title and/or axis or categorylabels native the above data, so the is useful to choose clear quick nameswhere possible.Excel defaults usually result in a chart that is reasonable but stillneeds customizing.The basic approachis to note that the chart has a number of areas:

Chart title Plot Area (the yes, really chart) The x-axis (for charts other than pie chart) which is referred to as acategoryaxis for tower or heat 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 column or heat chart and a classification axis because that a bar chart. Legend entry (explains the symbols provided in the chart) Labels because that the x-axis Labels because that the y-axis.To modify an existing chart one can pick the graph (click inside thechartand the border becomes highlighted).Then select within the chart that component of the chartyou great to adjust and rightclick to acquire the food selection for reformatting the chart.In some cases the chart Tools group with subgroups Design, Layout and Further details are offered below.


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

You are watching: The horizontal axis is also called the value axis

The data room in record healthexpendituresdata.csv


To create a shaft chart from the above

to mark the data andheadings (here columns A1:B13) select the Insert Tab and also Charts group and click on shaft Chart pick the very first of the 2-D column Charts (a clustered columnchart).This returns
Note the Excel supplies the an initial series (Category) for the x-axis labelsand the 2nd series (Expenditures) for the y-axis values.Also keep in mind the benefit to having the original data bespeak indescending value of expenditures. Tower CHARTS: CUSTOMIZING
The resulting tower chart is usually okay however prettierwith a betterchart title and the legend entrance dropped. Choose the Chart location by clicking on Expenditures at the height ofthechart. To change the font (size and type) best click and also select fontand make ideal changes in the Font dialog box. Change the surname to 1997 U.S. Wellness Expenditures(in $billion). To eliminate the expenditure entry in ~ the right, click onExpenditures then appropriate click and also select delete.PIE CHARTS

To produce a pie chartfrom the above

highlight the data andheadings (here columns A1:B13) pick the Insert Tab and also Charts group and also click on Pie Chart select the 2nd of the 2-D Pie Charts (an exploded pie chart).This yields
The resulting pie chart lacks al the group names and it could behelpfulto incorporate the portion breakdown.To obtain all category names select the legend area by clicking the legend. Move the legend approximately the peak of the figure. In ~ the center of the bottom traction on the box in the middle.We obtain
To gain the percentage break down choose the main chart area by click in the main chart area. Right-click to get the adhering to dialog box.
Click on add Data brand which offers the worths of theexpenditures (not percentages). Right click in the main chart area which offers the over dialogbox with the extra entry layout Data Labels. Click format Data Labels and also in the format Data brand dialogbox deselect Value and select Percentage.
Select close and we obtain

The heat chart is no really helpful for categorical data together above. The heat chartis best used for numerical data that space observed end time.

We consider monthly data top top the full return indigenous the standard andPoors 500 stock index (with reinvestment the dividends) native 1970 to1988.The data are in file SandP500stockpricedata.csvThe first few observations are


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

To create a line chart native the over

Highlight just the data because that TRSP500 (not the date) andthe headings (here columns B1:B1359) select the Insert Tab and Charts group and click on line Chart choose the very first of the 2-D heat 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 also right click.This yields the complying with dialog box
Choose pick Data to acquire the adhering to dialog box
Then click Edit to get the adhering to dialog box
Finally highlight the variety A2:A359 (note that the heading date is notincluded here). Pick OK in the Axis brand dialog crate Hit yes sir in the choose Data source dialog boxThis yields
The displayed dates can be decreased to whole numbers highlight the Horizintal (category) axis and right click. Pick Format Axis In the style Axis dialog box choose Number change from basic to Number; choose 0 decimal places; anduncheck use 1000 separator

A horiiontal axis deserve to be included by

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


A upright axis can an in similar way be added, wherein we eventually selectRotated Axis.

See more: I Want To Kiss You All Over Lyrics I Want To Kiss You All Over By Exile

We acquire



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


To resize the chart

Activate that by clicking when inside the chart. Place the allude of the arrow on one of the eight rectangularhandleslocated on the charts border and click and drag the mouse. The chartwill adjust size and also shape relying on the direction of thedrag. Experiment v the resizing until you get an idea of how it works.

To reposition a chart

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

To remove a graph from a worksheet

Activate it and then pressthe DELETE key.

For additional information on just how to use Excel go to http://ubraintv-jp.com/excel/excel.html