User Guide
Chapter 7 Creating Charts from Data 133
To give a dierent emphasis to your data, you can transpose the data so that data
points are grouped by region rather than by year. In this case, the data points for each
year are represented as a series of columns (data series); in this case each series has
only two data points and the groups of columns for each region are categories. So this
column chart contains two sets of four columns (data points), one category for Region
1 and one data set for Region 2.
The data sets contain one data
point (one bar) from each of the
four data series.
These two bars
represent one
data series.
Data series are represented dierently in dierent kinds of charts:
In  column charts and bar charts, a data series is represented by a series of columns or
bars in the same ll color or texture.
In a  line chart, a data series is represented by a single line.
In an  area chart, a data series is represented by an area shape.
In a  pie chart, only a single data set (the rst data point in each series) is represented
on the chart (whichever is listed rst in the table).
In a  scatter chart, each point on the graph is determined by both an x and a y value.
Two columns of values are plotted as x coordinates and y coordinates on a graph
representing the data points in a single data series.
To learn how to Go to
Create and edit a chart using data in one or more
tables
“Creating a Chart from Table Data” on page 134
Format chart titles, legends, axes, and other
elements
“Formatting Charts” on page 140
Format pie charts, line charts, and other particular
kinds of charts
“Formatting Specic Chart Types” on page 151