microsoft excel 2010- illustrated
DESCRIPTION
Microsoft Excel 2010- Illustrated. Unit D: Working with Charts. Objectives. Plan a chart Create a chart Move and resize a chart Change the chart design. Objectives. Change the chart layout Format a chart Annotate and draw on a chart Create a pie chart. Planning a Chart. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/1.jpg)
Microsoft Excel 2010- Illustrated
Unit D:Working with Charts
![Page 2: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/2.jpg)
Objectives
• Plan a chart• Create a chart• Move and resize a chart• Change the chart design
Microsoft Office 2010-Illustrated
![Page 3: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/3.jpg)
Objectives
• Change the chart layout• Format a chart• Annotate and draw on a chart• Create a pie chart
Microsoft Office 2010-Illustrated
![Page 4: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/4.jpg)
Planning a Chart• Chart planning guidelines
• Determine the purpose of the chart• Identify the data relationships you want
to communicate graphically• Determine results you want to see• Decide which chart type is most
appropriate
Microsoft Office 2010-Illustrated
![Page 5: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/5.jpg)
Planning a Chart• Chart planning guidelines
• Identify the worksheet data you want the chart to illustrate
• Understand the elements of a chart
Microsoft Office 2010-Illustrated
![Page 6: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/6.jpg)
Planning a Chart• Chart elements
• The horizontal axis (x-axis) is also called the category axis
• The vertical axis (y-axis) is also called the value axis
• The z-axis is present in 3-D charts
Microsoft Office 2010-Illustrated
![Page 7: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/7.jpg)
Planning a Chart• Chart elements
• Area inside the horizontal and vertical axes is called the plot area
• The scale of measure on the y-axis is identified by tick marks
• A legend makes it easy to identify each data series
Microsoft Office 2010-Illustrated
![Page 8: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/8.jpg)
Planning a Chart• Chart elements (cont.)
• A data point is the value in a cell you select for your chart
• A data marker visually represents each data point in the chart
• A group of related data points is a data series
Microsoft Office 2010-Illustrated
![Page 9: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/9.jpg)
Planning a Chart
Microsoft Office 2010-Illustrated
Data marker
Horizontal axis
Vertical axis
Tick marks Plot area
Legend
Chart elements Page 83-84
Data series
Gridline
![Page 10: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/10.jpg)
Planning a Chart
Microsoft Office 2010-Illustrated
Common chart types Page 81 Table D-1
![Page 11: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/11.jpg)
Creating a Chart• To create a chart:
• Select a range of data• Use buttons on the Insert tab of the
Ribbon to create and modify a chart
Microsoft Office 2010-Illustrated
![Page 12: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/12.jpg)
Creating a Chart• Sizing handles, the small series of
dots at the corners and sides of the chart’s border, indicate that the chart is selected
Microsoft Office 2010-Illustrated
![Page 13: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/13.jpg)
Creating a Chart• An embedded chart is one that is
inserted directly in the current worksheet
• A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data
Microsoft Office 2010-Illustrated
![Page 14: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/14.jpg)
Creating a Chart
Microsoft Office 2010-Illustrated
ClusteredColumn
chart type
Column charttypes
Column chart gallery Page 83 Figure D-3
![Page 15: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/15.jpg)
Moving and Resizing a Chart
• An object is an independent element on a worksheet• Moving a chart object does not affect
formulas or data• Resize a chart by dragging its sizing
handles; • Move a chart by dragging the chart
itself
Microsoft Office 2010-Illustrated
![Page 16: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/16.jpg)
Moving and Resizing a Chart
Microsoft Office 2010-Illustrated
Right-middlesizing handle
Moved and resized chart Let me show you…..
![Page 17: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/17.jpg)
Changing the Chart Design
• Changing data values in the worksheet automatically updates the chart
• Chart Tools tabs can be used to make specific changes in a chart
Microsoft Office 2010-Illustrated
![Page 18: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/18.jpg)
Changing the Chart Design
• Using the Chart Tools Design tab, you can:• Change the chart type• Modify the data range and configuration • Change the layout of objects • Choose from coordinating color
schemes • Move the location of the chart
Microsoft Office 2010-Illustrated
![Page 19: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/19.jpg)
Changing the Chart Design
Microsoft Office 2010-Illustrated
Currently selected chart
type
Chart typecategories
Change Chart Type dialog box
![Page 20: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/20.jpg)
Changing the Chart Layout
• Chart Tools Layout tab makes it easy to create and modify individual chart objects
• Using the Chart Tools Layout tab, you can:• Add shapes and text to a chart• Add and modify labels• Change the display of axes
Microsoft Office 2010-Illustrated
![Page 21: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/21.jpg)
Changing the Chart Layout
• Using the Chart Tools Layout tab, you can (cont.):• Modify the fill behind the plot area• Eliminate or change the look of
gridlines• Create titles for the horizontal and
vertical axes• Add graphics or background color
Microsoft Office 2010-Illustrated
![Page 22: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/22.jpg)
Changing the Chart Layout
Microsoft Office 2010-Illustrated
Axes titles added to chart
Vertical axis title
Vertical axis labels
Chart title
Horizontal axis labels
Horizontal axis title
Page 89 Figure D-13
![Page 23: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/23.jpg)
Formatting a Chart
• Chart Tools Format tab can be used to make formatting enhancements• Change colors in a specific data series• Apply a style to a series using the
Shape Styles group• WordArt, which lets you create curved
or stylized text, can be created using the WordArt Styles group
Microsoft Office 2010-Illustrated
![Page 24: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/24.jpg)
Formatting a Chart
Microsoft Office 2010-Illustrated
Live Preview of new style applied to data series
Style hovered over
Live Preview of hovered style
![Page 25: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/25.jpg)
Annotating and Drawing on a Chart• A text annotation is a label that you
add to a chart to further describe data
• You can add shapes such as arrows and boxes to a chart• Lines and arrows can be used to point
out exact locations you want to emphasize
Microsoft Office 2010-Illustrated
![Page 26: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/26.jpg)
Annotating and Drawing on a Chart
Microsoft Office 2010-Illustrated
Text annotation
Text annotation and arrow shape add to chart
Let’s look at Page 93
![Page 27: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/27.jpg)
Create a Pie Chart
• You can create multiple charts based on the same worksheet data• Different chart types can be better at
emphasizing different parts of the data• In a pie chart, emphasize a data
point by exploding, or pulling that slice away from the pie chart
Microsoft Office 2010-Illustrated
![Page 28: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/28.jpg)
Create a Pie Chart
• Backstage view can be used to preview, change settings and print
• In landscape orientation, the text runs the long way on the page
Microsoft Office 2010-Illustrated
![Page 29: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/29.jpg)
Create a Pie Chart
Microsoft Office 2010-Illustrated
Preview in Backstage view
Fit on One Page setting
Exploded pie slice
![Page 30: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/30.jpg)
Summary
• Plan a chart• Create a chart• Move and resize a chart• Change the chart design
Microsoft Office 2010-Illustrated
![Page 31: Microsoft Excel 2010- Illustrated](https://reader036.vdocuments.us/reader036/viewer/2022062410/56815f74550346895dce77ca/html5/thumbnails/31.jpg)
Summary
• Change the chart layout• Format a chart• Annotate and draw on a chart• Create a pie chart
Microsoft Office 2010-Illustrated