Microsoft Office Tutorials and References
In Depth Information
Basic Tasks with Charts
Basic Tasks with
Charts
poWer Users’ CliniC
Browsing Excel’s Chart Gallery
Excel pros sometimes find that the ribbon approach is a bit
awkward when you’re trying to find a less commonly used
chart type. In this situation, you may prefer to look at the
full list of chart types and subtypes. To do so, head to the
ribbon’s Insert➝Charts section, and then click the dialog
launcher (the square-with-an-arrow icon in the bottom-right
corner). You see the Insert Chart dialog box (Figure 19-3).
The Insert Chart dialog box doesn’t just let you create
charts. You can also designate the default chart type (the
one that’s used if you select some cells, and then press F11
to create a chart in a single bound). To designate a default
chart, select it, and then click “Set as Default Chart”.
Figure 19-3:
The gallery on the Insert Chart
dialog box’s right side has a
thumbnail of every chart
subtype, grouped by type. You can
scroll through them all, or you
can choose a type from the list
on the left to jump straight to
a specific section. When you
find what you want, click OK to
create it.
Layout . This tab lets you configure individual parts of the chart. You can add
shapes, pictures, and text labels, and you can configure the chart’s gridlines,
axes, and background.
Format . This tab lets you format individual chart elements, so you can
transform ordinary items into eye candy. You can adjust the font, fill, and borders
uses for chart titles and shapes, among other things.
Basic Tasks with Charts
Unlike the orderly rows of numbers and labels that fill most worksheets, charts float
above your data, locked inside special box-like containers. To take advantage of these
chart boxes, you need to understand a little more about how they work.
Search JabSto ::




Custom Search