Series

The Chart dashboard item supports a variety of series types - from simple bar and line charts to complex candle stick and bubble graphs.

To switch between series types in the Designer, click the options button next to the required data item (or placeholder) in the Values section. In the invoked Series Type dialog, select the required series type and click OK.

You can also do this using the Series Type gallery in the Design Ribbon tab.

Bar Series

A Bar series displays data as sets of rectangular bars with lengths proportional to the values that they represent.

This topic lists the available Bar series types.

Bar

 

Stacked Bar

 

Full-Stacked Bar

 

Point and Line Series

Point and Line series display data as standalone points or points joined by a line.

This topic lists the available Point and Line series types.

Point

 

Line

 

Stacked Line

 

Full-Stacked Line

 

Step Line

 

Spline

 

Area Series

 

An Area series displays data by a line that joins points, and the shaded area between the line and the argument axis.

This topic lists the available Area series types.

Area

 

Stacked Area

 

Full-Stacked Area

 

Step Area

 

Spline Area

 

Stacked Spline Area

 

Full-Stacked Spline Area

 

   
Range Series

 

A Range series is the area between two simple series displayed as a shaded area (Range Area), or bars that stretch from a point in one series to the corresponding point in another series (Range Bar).

This topic lists the available Range series types.

 

Range Bar

 

Range Area

 

Data Binding Specifics

 

Because a range series represents the area between two simple series, you need to provide two measures instead of one to display a range series.

  • Value 1 - a measure for calculating the first set of values.
  • Value 2 - a measure for calculating the second set of values.

When you select the Range Bar or Range Area series type in the Designer, the Data Items area displays two data item placeholders.

Weighted Series

A Weighted series displays data using a third dimension, expressed by a bubble's size.

This topic lists the available Weighted series types.

Bubble

 

Data Binding Specifics

 

 

Data points in a weighted series present the following two measures:

  • Value - the Y-coordinate of series points;
  • Weight - the size of series points.

When you select the Bubble series type in the Designer, the Data Items area displays two data item placeholders.

Financial Series

Financial series are useful in analyzing stock and bond prices, as well as the behavior of commodities.

This topic lists the available Financial series types.

High-Low-Close

 

 

Data Binding:

Data points in a High-Low-Close series present three measures.

  • High - the maximum price within the specified period (the top of the series point).
  • Low - the minimum price within the specified period (the bottom of the series point).
  • Close - the price at the end of the specified period (the tick mark).

When you select the High-Low-Close series type in the Designer, the Data Items area displays three data item placeholders.

Candle Stick

 

 

Data Binding:

Data points in a High-Low-Close series present four measures.

  • Open - the price at the beginning of the specified period (the body top).
  • High - the maximum price within the specified period (the upper shadow top).
  • Low - the minimum price within the specified period (the lower shadow bottom).
  • Close - the price at the end of the specified period (the body bottom).

When you select the Open-High-Low-Close series type in the Designer, the Data Items area displays four data item placeholders.

Stock

 

 

Data Binding:

Data points in a High-Low-Close series present four measures.

  • Open - the price at the beginning of the specified period (the left tick mark).
  • High - the maximum price within the specified period (the top of the series point).
  • Low - the minimum price within the specified period (the bottom of the series point).
  • Close - the price at the end of the specified period (the right tick mark).

When you select the Open-High-Low-Close series type in the Designer, the Data Items area displays four data item placeholders.