Microsoft Office Tutorials and References
In Depth Information
Chapter 12: Working with Charts
Create a Chart
You can quickly convert your spreadsheet data into easy-to-read charts. You can create
column, line, pie, bar, area, scatter, stock, surface, doughnut, bubble, and radar charts.
Excel even recommends the type of chart that works best for your data. If you do not like Excel’s
recommendations, you can select the chart of your choice.
You can create charts using the Ribbon or using the Quick Analysis button. After you create a chart,
you can use buttons beside the chart or on the Chart Tools tabs to fine-tune the chart to best display
and explain the data.
Create a Chart
Using the Ribbon
1 Select the range of data that you
want to chart.
You can include any headings and
labels, but do not include subtotals
or totals.
2 Click the Insert tab.
3 Click Recommended Charts .
The Insert Chart dialog box appears.
4 Scroll through the recommended
charts.
A A preview of your data appears.
B If you do not see the chart you want
to use, click All Charts .
5 Click a chart type.
6 Click OK.
C Excel creates a chart and places it in
the worksheet.
D Whenever you select the chart, Chart
Tools tabs appear on the Ribbon.
E You can use the Chart Elements
( ), Chart Styles ( ), and Chart
Filters ( ) buttons to add chart
elements like axis titles, customize
the look of your chart, or change the
data in the chart.
210
Search JabSto ::




Custom Search