Changing Chart Type

Recommended Charts

The Recommended Charts tab contains most appropriate chart types for selected data. The appropriate charts are selected based on the source data, available dimensions and selection in them.

All Charts

The All Charts tab contains all chart types and advanced settings are available.

NOTE. On changing chart type the previously configured binding of series to secondary axis is saved for all chart types, except for the histogram with grouping and the stock exchange chart with the opening rate.

To set up chart scale orientation, select chart orientation option in the Chart Type dialog box.

Chart scale orientation setup is available for any type of charts except for pie, doughnut, radar, secondary histogram and secondary pie chart.

For detailed description of working with the setting see the Setting Up Scale Orientation section.

Data labels contain information on series or specific data points.

To display data labels on the chart, select the Show Data Labels checkbox.

For detailed description of working with the setting see the Setting Up Data Labels section.

Series smoothing is used to avoid curved line effect, which occurs on plotting a chart (line, scatter with connecting lines and for series of the Line type in the mixed chart).

To set up smoothing of linear series of chart, select the Smooth Series checkbox.

For detailed description of working with the setting see the General Settings of Data Series section.

To show the frequency of value falling into different intervals, select the Frequency Chart checkbox.

The setting is available for all chart types except for 3D histogram with groups, pie chart, radar chart, stock exchange and histogram with fluctuation intervals.

Below is the example of a histogram of a regular chart (left) and a frequency chart (right):

NOTE. Frequency chart parameters can be set up only via the Fore language.