Microsoft Office Tutorials and References
In Depth Information
Adding More Data to an Existing Chart
Chart
Area
Chart
Title
Sales
8
Plot
Area
7
6
5
Legend
Sales
Y
Axis
4
Data
Point
3
2
1
0
X
Axis
Jun
Jul
Aug
Sep
Oct
FIGURE 6.8 Chart Parts
For the legend or data table: Youmay show or hide a legend, change its location, or
even change the legend entries. You can display a data table (the data used to build the
chart). The legend keys can be formatted to have the appearance of your chart elements.
I will discuss these and other chart options when charts will be used in upcoming
chapters. I will discuss them in the context of trend lines, formatting, and other
situations.
ADDING MORE DATA TO AN EXISTING CHART
Look again at the previous example. For reference, it is illustrated once more in
Figure 6.9. The chart was created from the two first columns of the data. The Months
FIGURE 6.9 The Initial Chart before Adding More Data
 
Search JabSto ::




Custom Search