Quick Reference Microsoft Excel 2010 Charts
47 Greenaway Street Bulleen Victoria 3105 Australia www.watsoniapublishing.com
[email protected]
Generated using EngineRoom™ Profiler on 13/10/2010
Microsoft Excel 2010 Charts
Table of Contents Creating Charts .............................................................................................................. 2 Charting Techniques ...................................................................................................... 3
Quick Reference
Chart Object Formatting................................................................................................. 5
© 2010, Watsonia Publishing
Page 1
Microsoft Excel 2010 Charts
Creating Charts To select a chart and its objects: 1.
Click on the border of the chart to select an embedded chart
2.
Click on the various objects of a chart to select them
To move a chart: 1.
Click on the chart to select it
2.
Move the mouse pointer to the border of the chart until the mouse pointer changes to a four-headed arrow
3.
Drag the chart to a new location
To change the chart type: 1.
Ensure the chart or chart sheet is selected
2.
Click on the Design tab on the Ribbon and click on the Change Chart Type tool in the Type group
3.
Click on the desired chart and click on [OK]
Quick Reference
To change the chart style: 1.
Ensure the chart or chart sheet is selected
2.
On the Design tab click on the More button
3.
Click on the desired style
for the Chart Styles group
To delete a chart: 1.
Click on the worksheet to see the chart, then click on the chart to select it
2.
Press
To create a chart: 1.
Select the range to chart
2.
Click on the Insert tab of the Ribbon, and click on the Column tool the Charts group
3.
Click on the desired chart type
in
To resize a chart: 1.
Drag one of the eight sizing handles on the border of a selected chart
OR: 1.
Click on the up/down buttons of the Shape Height and Shape Width tools
© 2010, Watsonia Publishing
Page 2
Microsoft Excel 2010 Charts
To create a chart sheet: 1.
Click on the Design tab on the Ribbon, then click on the Move Chart tool in the Location group
2.
Click on New Sheet, type a name for the sheet and click on [OK]
To change the chart layout: 1.
Ensure the chart or chart sheet is selected
2.
On the Design tab, click on the More button
3.
Click on the desired layout
for the Chart Layouts group
To embed a chart in a worksheet: 1.
Click on the Design tab on the Ribbon, then click on the Move Chart tool in the Location group
2.
Click on the drop arrow on [OK]
and select the sheet to embed it into, then click
Charting Techniques
Quick Reference
To add a chart title: 1.
Click on Chart Title
in the Labels group on the Chart Tools: Layout tab
2.
Select a position option
3.
Type the title text and press
To position a legend: 1.
On the Chart Tools: Layout tab, click on Legend
2.
Select a position option
To show a data table: 1.
Click on Data Table
2.
Select an option
To modify the axis: 1.
Click on Axes
2.
Point to Primary Horizontal Axis and Primary Vertical Axis
3.
Select an option
To show gridlines: 1.
On the Chart Tools: Layout tab, click on Gridlines
© 2010, Watsonia Publishing
in the Axes group
Page 3
Microsoft Excel 2010 Charts
2.
Point to Primary Horizontal Gridlines or Primary Vertical Gridlines
3.
Select an option
To add a trendline: 1.
Click on Trendline
2.
Select an option
3.
Click on the data series you want to create a trend from
4.
Click on [OK]
To add a text box: 1.
On the Chart Tools: Layout tab, click on Text Box
2.
Click on the chart and type the text
3.
Resize and reposition the text box if necessary
To use font formatting and alignment: 1.
Click on the chart element to select it
2.
Click on the tool in the Font or Alignment group on the Home tab
Quick Reference
To change text fill: 1.
Click on the text element to select it
2.
Click on the drop arrow for Text Fill
and select the required option
To change text effects: 1.
Click on the element to select it
2.
Click on Text Effects
3.
Click on the effect
and point to the category of effect you want
To add axes titles: 1.
Click on Axis Titles
2.
Point to Primary Vertical Axis Title or Primary Horizontal Access Title
3.
Select the required option
4.
Type the title text then press
To show data labels: 1.
On the Chart Tools: Layout tab, click on Data Labels
2.
Select the required position
© 2010, Watsonia Publishing
Page 4
Microsoft Excel 2010 Charts
To format the plot area: 1.
On the Chart Tools: Layout tab, click on Plot Area
2.
Select More Plot Area Options
3.
Make the required selections
4.
Click on [Close]
To add error bars: 1.
On the Chart Tools: Layout tab, click on Error Bars
2.
Select an option
To use WordArt Styles on chart text: 1.
Click on the chart element
2.
On the Chart Tools: Format, click on the More button and click on the required style
for WordArt Styles
To change text outline: 1.
Click on the text element to select it
2.
On the Chart Tools: Format tab, click on the drop arrow for Text Outline and select the required option
Quick Reference
Chart Object Formatting To select chart elements: 1.
Click on the element
OR 1.
Click on the drop arrow name
for Chart Elements and click on the element
To change column colour: 1.
Click on the column in the series to select it
2.
Click on the drop arrow for Shape Fill
3.
Click on the colour of your choice
To apply a shape effect: 1.
Click on a shape to select it
2.
Click on Shape Effects
3.
Point to the shape effect you want then select an option
© 2010, Watsonia Publishing
Page 5
Microsoft Excel 2010 Charts
To use the Format dialog box: 1.
Click on the chart element
2.
Click on Format Selection
3.
Make the required changes
4.
Click on [Close]
To use a shape style to format a chart object: 1.
Select the chart object
2.
Click on the More button
for Shape Styles and select the style
To change the colour of a pie slice: 1.
Click on the pie chart to select it
2.
Click on the individual slice
3.
Click on the drop arrow for Shape Fill
4.
Click on the required colour
To fill the plot area or chart area: 1.
Click on the plot area or chart area
2.
Click on the drop arrow for Shape Fill
and select an option
Quick Reference
To apply a theme to a chart: 1.
Select the chart
2.
Click on the Page Layout tab then click on Themes
3.
Select the required theme
© 2010, Watsonia Publishing
Page 6