Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Charming Charts and Gorgeous Graphics
Figure 10-6 illustrates how the sample clustered column chart looks with a
data table added to it. This data table includes the legend keys as its first
column.
If you decide that displaying the worksheet data in a table at the bottom of the
chart is no longer necessary, simply click the None option on the Data Table
button’s drop-down menu on the Layout tab of the Chart Tools contextual tab.
Editing the generic titles in a chart
When Excel first adds titles to a new chart, it gives them generic names, such
as Chart Title and Axis Title (for both the x- and y-axis title). To replace these
generic titles with the actual chart titles, click the title in the chart or click
the name of the title on the Chart Elements drop-down list. (Chart Elements
is the first drop-down button in the Current Selection group on the Format
tab under Chart Tools. Its text box displays the name of the element
currently selected in the chart.) Excel lets you know that a particular chart title
is selected by placing selection handles around its perimeter.
Figure 10-6:
Embedded
clustered
column
chart with
data table
with legend
keys.
Search JabSto ::




Custom Search