The Chart type of panel provides a wide range of chart types that are based on a table of data. There are other panel types that provide other specific styles of chart presentation that do not fit the same structure.

The chart type available are:

• Line
• Column
• Lollipop
• Pie
• Donut
• Semicircle
• Area
• Bar
• Spline
• Area Spline
• Area Range
• Area Spline Range
• Column Range
• Dumbbell
• Cylinder
• Pyramid
• Pyramid 3D
• Column Pyramid
• Funnel
• Funnel 3D
• Variable Pie
• Error Bar
• Bubble
• Packed Bubble
• Vari-wide
• Boxplot
• Bullet
• Stream Graph

The Chart Settings page displays a sample of your setup on the right side. This uses dummy data but gives an indication of how your chart will look. Step though the chart types to see what each one looks like.

This example of a line chart also has some other settings applied.

The following settings are available. Not all apply to all chart types; the settings page will guide you as to which are applicable.

If checked, the chart's axes are set around a circle and along its radius.

Polar is only applicable to some chart types.

By default, charts such as line or column, have their values placed on the chart against their value. Stacking lets you accumulate the values putting the values of each series on top of each other.

There are three stacking options:

• By Value - the natural values are accumulated
• By Percentage - the natural values are converted to percentages of the sum of all series
• Stream - only applicable to Stream Graph

If checked, the data values will be displayed next to each item in the chart. This can be useful but will over complicate a chart with many series and categories.

Text to show on the left side of the chart to describe the values (e.g. Kgs, Attendees, Orders).

Some charts may be displayed in three dimensions. Check to make 3D.

Many charts have an option to display with animation, which gives the chart more attention, especially if it is changed by filters in the dashboard.

If Sorting is enabled the chart data will be ordered. Note that this is not effective in all chart types.

By default, the columns of a table are taken to be the categories of data with the label of each being the category name. Sometimes it is necessary to pivot the data so that one column represents the categories and each row has the data values for the chart; this is the Row option.

A more complex option is the Matrix Series Data. This lets you generate a matrix of data by specifying a numeric field and then the fields that represent the series and categories, and their names. All of these fields will be allocated automatically if you do not specify them.

The data is created by taking each record in the data and creating the matrix of series and category values.

Generally the above settings will create the required chart but you may wish to specify the fields to be used for each series, or mix different types of charts in one panel (the above sample chart is set this way).

Click the + icon to add a series settings definition. For each series you can specify the chart type, or leave it as the main chart type for the panel.

You will then be able to specify the field to be used for each series value required for the type. In many cases this is the single value for that series. However, some types such as Area Range require more than one value, so you will asked to specify each. Any of these entries not specified will allow fPanels to allocate fields automatically from the data.

Note that if the Series Data is Column, the fields are presented as select lists, otherwise you must enter the value you expect to be found in the data.

Finally you can enter a name for the series to override the default name (taken from the data).

Sometimes it is useful to add bands and lines behind your chart as a guide to the content, for example to show RAG rated values or mark min and max levels. You can add as many bands and lines as are required.

Choose a band or a line. For a band, enter the from/to values; for a line, enter the value at which the line will be drawn.

Select the colour of the band or line by clicking on the corresponding box.

The optional Label will be shown within the band or on the line to describe it.

For a line, select the Dash Style from a choice of solid, dashes, dots or a mixture.

This is an advanced option to permit custom settings to be applied to the series' when not available in the Designer Chart page. It requires a detailed knowledge of the underlying chart generator, HighCharts.

The entry is a JSON object containing an array of series definitions. These are applied ahead of those in the design.

Please go to Highcharts for more information about Series.