A BI Beans graph displays series and groups of data. Series and groups are analogous to the rows and columns of a crosstab. So, by default, when you display the same data in a crosstab and in a graph, the rows in the crosstab appear as series in the graph. For most graph types, the columns in the crosstab appear as the groups in a graph.
You can set the DataRowShownAsASeries
property of the graph to
false
, to have the columns of a crosstab displayed as the series in the graph.
Then for most graph types, the rows in the crosstab appear as the series in the graph.
Several graph types represent more than one value as a group value. For example, a scatter
graph has two group values for each data marker. The first value determines where the marker
appears along the X-axis, while the second value determines where the marker appears along the
Y-axis. Bubble graphs require three values in each group, and stock graphs can require as many
as five values for each group. In a graph where DataRowShownAsASeries
is
true
, this means that the graph requires five columns of data for each group.
In most graphs, a series appears as a set of markers that are the same color. For example, in a multiple pie graph, each yellow slice might represent sales of shoes, while each green slice represents the sales of boots. In a bar graph, all of the yellow bars might represent the sales of shoes, and the green bars might represent the sales of boots.
Groups appear differently in different graph types. In a clustered bar graph, each cluster of bars is a group. In stacked bar graph, each stack is a group. In a multiple pie graph, each pie is a group.
Topics in this Help system for each graph type describe how series and groups are displayed
in the graph type. All of the topics assume that DataRowShownAsASeries
is
true
. If you set DataRowShownAsASeries
to false
, then
you should reverse rows and columns as you present data to the graph. For example, when
DataRowShownAsASeries
is false
, a scatter graph requires two rows of
data for each group, rather than two columns.