The Series tab appears in the ribbon only when you are working
with charts. It provides access to chart options through the Select,
Properties, Line, Pie, and Display groups. The Series tab is shown
in the following image.
x
The Select group contains a drop-down menu for selecting
a specific measure field to which to apply one or more of the options
that are available in the Series tab. The default setting is All
Series, which applies the selected options to all the measure fields
in the report.
x
The Style group contains the following command for modifying
the style options for the selected series in a chart:
-
Style. Opens
the Format Series dialog box, where you can edit the styling options
for the selected series. You can also open this dialog box by right-clicking
a series, and then clicking More Style Options.
For more information, see Formatting a Series.
x
The Properties group contains the following commands for
enhancing charts:
-
Data
Labels. Adds data labels to the chart. The drop-down menu contains
the following data position options for selecting where to display
data values as labels on a chart:
- Above (default)
- On top edge
- Below top
edge
- Center
- Base
Clicking More Data Label Options opens
the Format Labels dialog box, where you can further edit your data
labels. For more information, see Formatting Data Labels.
-
Type. Opens
a drop-down menu with the following options for selecting different
chart types:
- None (default)
- Bar
- Line
- Area
Note: When you make a change
to the chart type using the Type button on the Series tab, changes
to the chart type on the Format tab are overwritten.
-
Trendline. Opens
a drop-down menu that provides the following options for adding
a trendline to a chart:
- None (default)
- Linear
- Quadratic
- Polynomial
- Hyperbolic
- Logarithmic
- Modified Hyperbolic
- Rational
- Exponential
- Modified Exponential
- Log Quadratic
- Geometric
Note:
- The trendline option
is not available in HTML5.
- The
trendline option is not available in InfoAssist Basic.
For more information, see How to Add a Trendline.
-
Equation. Displays
the associated mathematical equation for the selected trendline
on the chart.
Note:
- The equation is not
available in HTML5.
- The
equation option is not available in InfoAssist Basic.
x
The Line group contains the following options for formatting
chart lines and line markers:
-
Smooth
Line. Draws the chart using smooth lines. For more information,
see How to Apply Smooth Line Effect to a Line Chart.
Note: The smooth line option is not available in InfoAssist Basic.
-
Connect
Lines. Controls the display of connecting lines between markers
on a line or scatter chart. By default, lines are connected on a
line chart and disconnected on a scatter chart.
-
Marker. Opens
a drop-down menu from which you can select options to change the
display of the default data and legend markers on line and scatter chart
types. The drop-down menu contains the following options:
- None
- Square
- Circle
- Diamond
- Plus
- Triangle Down
- Triangle Up
- Triangle Right
- Triangle Left
- Pirate Plus
- House
- Hexagon
- Fat X
- Five Star
- Six Star
- Hourglass
- Sideways Hourglass
- Horizontal Line
- Vertical Line
- Area
For more information, see How to Change the Appearance of a Marker.
Note: The marker
option is not available in InfoAssist Basic.
x
The Pie group contains options to expand or hide pie slices.
The Pie group is activated only when you click Pie on
the Format tab, in the Chart Types group.
Note: The
pie options are not available in InfoAssist Basic.
x
The Display group contains the Reverse Order command to
reverse the order of a series when All Series is
selected in the Select group.
The Reverse Order option is available for all chart types.