Show TOC

 Class 1 Chart TypesLocate this document in the navigation structure

Class 1 includes the following chart types:

  • Line and profile charts
  • Column and bar charts
  • Doughnut charts
  • Radar charts
  • Area and profile area charts
  • Pie charts
  • Polar charts
  • Speedometers
  • Split pie charts

Structure of the Data Provider

You build the underlying table of the chart types of class 1 (with the exception of pie charts and speedometers) as follows:

  • The data columns correspond to the categories.
  • The rows contain the values for each category.Each row is converted into a data series in the chart.

Structure of the Data Provider for a Pie Chart

In a pie chart, the underlying table has only one row.The values in the columns form the pie segments.

If the table contains more than one row, the additional rows are ignored when the table is converted into a chart.However, you can define which row is to be used (see below).

Structure of the Data Provider for a Speedometer

In a speedometer, the underlying table has only one data column.Each value in the data column is displayed in the chart as a pointer.The speedometer will be readable if the data column does not contain too many values.

If the table contains more than one data column, the additional columns are ignored when the table is converted into a chart.You can define which data column is to be used for the speedometer.

 

The following data table is the basis for the charts below.

  • Line and profile charts
  • Column and bar charts
  • Doughnut charts
  • Radar charts

You could also generate a split pie chart from this data source. However, we chose another example in order to clarify the possibilities for this chart type.

Most of the examples mentioned here were created using the chart attribute Switch Axes to Display (SWITCHMATRIX='X'). (Exceptions are mentioned in the relevant sections.)

Line Chart

Data trends are shown in a line chart.The data is entered at regular intervals.Categories such as items groups are normally entered on the X axis and values such as revenue on the Y axis.

Chart

Special features

For line charts you can set the manner in which the lines pass between data points - direct as in the example above, as curved lines, or in varying increments. To do so, choose Data Series Format → <name of series> → Line Type.

Profile Chart

In a profile chart the lines are arranged vertically and not horizontally as in a line chart. Otherwise the profile chart corresponds to the line chart.

Chart

Special features

For profile charts you can set the manner in which the lines pass between data points - direct as in the example above, as curved lines, or in varying increments. To do so, choose Data Series Format → <name of series> → Line Type.

Column chart

Comparisons between individual elements are shown in a column.Categories are arranged horizontally and values are arranged vertically.

To show changes within a certain time interval, you can use either column charts or XY scatter charts.

Chart

Special features

In a three-dimensional column chart you can also depict the columns as cylinders, cones, or pyramids (see Formatting 3D Effects ).

In a two-dimensional column chart you can depict the columns as triangles (two-dimensional pyramids). To do this, choose Columns → BlockStyle.If you are using a two-dimensional column chart, there is no difference between the setting Pyramid and the setting Cone.

Bar Chart

Comparisons between individual elements are shown in a bar chart.Categories are arranged vertically and values are arranged horizontally.The emphasis is on the comparison of values and not on displaying a change during a period of time.

Chart

Special features

In a three-dimensional bar chart you can also depict the bars as cylinders, cones, or pyramids (see Formatting 3D Effects ).

In a two-dimensional bar chart you can depict the bars as triangles (two-dimensional pyramids). To do this, choose Bars → BlockStyle.If you are using a two-dimensional bar chart, there is no difference between the setting Pyramid and the setting Cone.

Doughnut Chart

As in a pie chart, the relationship between parts of a whole are displayed in a doughnut.In contrast to the pie chart, the doughnut can represent more than one data series, where each ring corresponds to a data series.

Chart

Special features

You can change the width of the rings by setting the hole size. To do so, choose Doughnut → Hole Size → <value as percentage of ring size>.

Radar Chart

In a radar chart, each category has its own value axis emanating from the middle.The values of a data series are linked with lines.

Radar charts can be used to compare data series: The data series with the highest values occupies the most space.

Chart

 

Special features

You can also depict the chart areas filled in.Choose Radar → Filled to do so.Depending on the size of the individual data series, the areas may overlap.

 

The following data table is the basis for the charts below.

  • Area charts
  • Profile area charts
  • Pie charts
  • Polar charts
  • Speedometers

Area Chart

The area between the axes and the data series are filled in an area chart.Otherwise the area chart corresponds to the line chart.

A stacked area chart depicts the sum of the applied values, thereby illustrating the relationships of parts to each other.

Chart

Special features

You can determine the line type in an area chart in the same way as for a line chart.

Note

The line type Curve is not supported for an area chart.

Profile Area Chart

In a profile chart the areas are arranged vertically and not horizontally as in an area chart. Otherwise the profile chart corresponds to the area chart.

Chart

Special features

You can determine the line type in a profile area chart in the same way as for a profile chart.

Note

The line type Curve is not supported for a profile area chart.

Pie Chart

In a pie chart, the proportional part of elements of a data series are displayed in a whole.This chart type has only a single data series and is used primarily to highlight a particularly important element.

Chart

 

Special features

A pie chart only reads a single data series from a data source and ignores all others.You can determine which series is to be used by choosing Pie → Series Index → <number of table series>.

You can also determine how much of the drawing area a pie chart should take up. To do so, choose Pie → UsedSpace → <value as percentage of drawing area>.

You can also pull out the individual pie segments by choosing Pie → ExplosionOffset → <value in pixels>.

See also:

Formatting 3D Effects

Rotating Charts

Polar Chart

As for a radar chart, each category has its own value axis.The values of a data series are depicted as areas.

Chart

  

Special features

A polar chart only reads a single data series from a data source and ignores all others.You can determine which series is to be used by choosing Polar → Series Index → <number of series>.

Speedometer

A speedometer displays one or more key figures in the form of a pointer.The speedometer is divided into several value ranges and the user immediately sees the value range in which the pointer is currently positioned.

A speedometer only displays one data column of the data provider.

Chart (axes not switched for display)

Special features

You can determine which data column is to be displayed by choosing Speedometer → Data Index → <number of data column>.

You can determine whether to display the categories as pointers rather than the data column by choosing Speedometer → UseCategories.

You can define whether the pointers are to have arrows by choosing Speedometer → Show Arrows.

You cannot display speedometers in 2.5D or 3D.

Split Pie Chart

In a split pie chart several data series are displayed per category as a pie segment, and are depicted in proportion to each other.

Data Provider

Chart (axes not switched for display)

Special features

See Rotating Charts .