Microsoft Office Tutorials and References
In Depth Information
system quite useful, in spite of the occasional difficulty of finding functionality that
I was accustomed to before Excel 2007. Exhibit 2.2 shows the Insert tab where the
Charts group is found.
In this exhibit, a very simple graph of six data points for two data series,
data1 and data2 , is shown as two variations of the column graph. One also dis-
plays the data used to create the graph. Additionally, since the leftmost graph
has been selected, indicated by the border that surrounds the graph, a group
of menus appear at the top of the ribbon— Chart Tools . These tools contain
menus for Design, Layout, and Format. This group is relevant to the creation of
a chart or graph. Ultimately, ribbons lead to a flatter, or less hierarchical, menu
system.
Our first step in chart creation is to organize our data in a worksheet. In Exhibit
2.2 the six data points for the two series have a familiar columnar orientation and
have titles, data1 and data2 . By capturing the data range containing the data that
you intend to chart before engaging the charts group in the Insert tab, you auto-
matically identify the data to be graphed. Note that this can, but need not, include
the column title of the data specified as text. By capturing the title, the graph will
assume that you want to name the data series the same as title selected. If you place
alphabetic characters, a through f, in the first column of the captured data, the graph
will use these characters as the x-axis of the chart.
If you prefer not to capture the data prior to engaging the charts group, you can
either: (1) open and capture a blank chart type and copy the data and paste the
data to the blank chart type, or (2) use a right click of your mouse to select data .
Obviously, there will be numerous detailed steps to capturing data and labeling the
Exhibit 2.2
Insert tab and excel chart group
Search JabSto ::




Custom Search