Microsoft Office Tutorials and References
In Depth Information
Exhibit 2.10 Step 2-select data source dialogue box
must specify the range where the axis labels are located. You can see that our axis
labels are located in range A2:A9.
In Exhibit 2.10 we can see the partially completed chart. A right click on the
chart area permits you to once again use the Select Data function. The dialogue box
that appears permits you to select the new Horizontal (Category) Axis Labels .By
depressing the Edit button in the Horizontal Axis Labels window, you can capture
the appropriate range (A2:A9) to change the x-axis. This is shown in Exhibit 2.11.
Step 3 of the process permits titles for the chart and axes. Exhibit 2.12 shows
the selection of layout in the Design tab Charts Layout group. The Layout and the
Format tabs provide many more options for customizing the look of the chart to
your needs.
As we mentioned earlier, many details for a chart can be handled by pointing
and right clicking; for example, Select Data , Format Chart Area , and Chart Type
changes. Selecting a particular part of the graph or chart with a left click, for exam-
ple an axis or a Chart Title , then right clicking, also permits changes to the look
of the chart or changes in the axes scale, pattern, font, etc. I would suggest that you
take a simple data set, similar to the one I have provided, and experiment with all
the options available. Also, try the various chart types to see how the data can be
displayed.
Search JabSto ::




Custom Search