Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Charming Charts and Gorgeous Graphics
Insert Pie or Doughnut Chart to preview your data as a 2-D or 3-D pie
chart or 2-D doughnut chart
Insert Scatter (X,Y) or Bubble Chart to preview your data as a 2-D
scatter (X,Y) or bubble chart
When using the galleries attached to these chart command buttons on the
Insert tab to preview your data as a particular chart style, you can embed the
chart in your worksheet by simply clicking its chart icon.
If you’re not sure what type of chart best represents your data, rather than
go through the different chart type buttons on the Ribbon’s Insert tab, you
can use the All Charts tab of the Insert Chart dialog box shown in Figure 10-2
to try out your data in different chart types and styles. You can open the
Insert Chart dialog box by clicking the Dialog Box launcher in lower-right
corner of the Charts group on the Insert tab and then display the complete
list of chart types by clicking the All Charts tab in this dialog box.
Figure 10-2:
Insert Chart
dialog box
with the All
Charts tab
selected
where you
can preview
and select
from a wide
variety of
chart types
and styles.
Charts via the Quick Analysis tool
For those times when you need to select a subset of a data table as the range to
be charted (as opposed to selecting a single cell within a data table), you can
use the new Quick Analysis tool to create your chart. Just follow these steps:
Search JabSto ::




Custom Search