chart unit - rancocas valley regional high school · 1/10/2011 · chart type categories change...
Post on 17-Sep-2020
2 Views
Preview:
TRANSCRIPT
1/10/2011
1
Microsoft Office 2007Microsoft Office 2007-- Illustrated Introductory, Illustrated Introductory, Premium Video EditionPremium Video Edition
Working with ChartsWorking with Charts
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
•• Chart planning guidelinesChart planning guidelines•• Determine the purpose of the chartDetermine the purpose of the chart•• Identify the data relationshipsIdentify the data relationships•• Determine results you wantDetermine results you want•• Decide which chart type is most Decide which chart type is most
appropriateappropriate•• Identify the worksheet data you want the Identify the worksheet data you want the
chart to illustratechart to illustrate•• Understand the elements of a chartUnderstand the elements of a chart
Planning a ChartPlanning a Chart
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Data marker
Horizontal axis
Vertical axis
Tick marks
Data point
Legend
Plot area
Chart elementsChart elements
Planning a ChartPlanning a Chart
Data series
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Common chart typesCommon chart types
Planning a ChartPlanning a Chart
1/10/2011
2
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Creating a ChartCreating a Chart•• To create a chart:To create a chart:
•• Select a range of dataSelect a range of data•• Use buttons on the Insert tab to create Use buttons on the Insert tab to create
and modify a chartand modify a chart•• EmbeddedEmbedded chartchart
•• inserted directly in the current worksheetinserted directly in the current worksheet
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Creating a ChartCreating a Chart•• Sizing handlesSizing handles
•• the small series of dots at the corners the small series of dots at the corners and sides of the chart’s borderand sides of the chart’s border
•• indicate that the chart is selectedindicate that the chart is selected•• Chart sheetChart sheet
•• Sheet in a workbook that contains only a Sheet in a workbook that contains only a chartchart
•• Linked to the workbook dataLinked to the workbook data
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Creating a ChartCreating a Chart
ClusteredColumn
chart type
Column charttypes
Column chart paletteColumn chart palette
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Moving and Resizing a Chart Moving and Resizing a Chart
Middle-rightsizing handle
Moved and resized chartMoved and resized chart
1/10/2011
3
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Changing the Chart DesignChanging the Chart Design
Currently selected chart
type
Chart typecategories
Change Chart Type dialog boxChange Chart Type dialog box
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Changing the Chart LayoutChanging the Chart LayoutAxes titles added to chartAxes titles added to chart
Vertical axis title
Vertical axis labels
Chart title
Horizontal axis labels
Horizontal axis title
Chart Elements list arrow
Axis Titles button
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Formatting a ChartFormatting a ChartFormat Data Series dialog boxFormat Data Series dialog box
Click Border Color tocontrol line display
Click Shadow tocontrol shadow
settings
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Create a Pie ChartCreate a Pie Chart
•• Create multiple charts based on the Create multiple charts based on the same worksheet datasame worksheet data
•• In a pie chartIn a pie chart•• Emphasize a data point by Emphasize a data point by exploding exploding a a
slice awayslice away•• In In landscapelandscape orientationorientation
•• text runs the long way on the pagetext runs the long way on the page
1/10/2011
4
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Create a Pie ChartCreate a Pie Chart
Exploded pie sliceExploded pie slice
top related