Dashboard chart types

When you select the Chart icon on the Chart properties dialog box, the available chart types display as icons in rows organized by chart type. This section provides information about each chart type, including illustrations of each button. The following table provides a quick reference to the Web Dashboard chart and chart types that are available:

Chart Chart types
Column charts
  • Column Chart
  • Column Chart 3D
  • Stacked Column chart
  • Stacked Column chart 3D
  • Bar Chart In Rows
  • Stacked Column Chart (%)
Gauge charts
  • Gauge Chart
  • Gauge Chart 2
  • Horizontal Gauge Chart
  • Vertical Gauge Chart
Line and Area charts
  • Line Chart
  • Line Chart 3D
  • Line Chart (Time Axis)
  • Line Chart 3D (Time Axis)
  • Pareto Chart
  • Bar Line Chart
  • Area Chart (Time Axis)
  • Area Chart
  • Stacked Area Chart
  • Stacked Area Chart (Time Axis)
  • Line and Line Chart
  • Line and Line Chart (Time Axis)
  • Stacked Step Chart (Time Axis)
  • Step Chart (Time Axis)
  • Stacked Bar Line Chart
Pie and bar charts
  • Pie Chart
  • Pie Chart 3D
  • Bar Chart
  • Bar Chart 3D
  • Pie Chart In Bar
  • Horizontal Bar Chart
  • Donut chart
Other charts
  • Table
  • Radar Chart
  • Map Chart
  • Age Chart
  • Color Table Chart
  • Gantt View Chart
  • Scatter Plot Chart
  • Bubble Plot Chart
  • Funnel Chart
  • Kiviat

Column charts

Column Chart small column chart and Column Chart 3D

These charts show comparisons among categories by vertical bars. It is produced using the input data set as follows:

  • The first column contains the specific categories being compared. They are shown along the X-axis.
  • The following columns represents discrete values that will be displayed by vertical bars positioned in the corresponding categories.

Stacked Column Chart and Stacked Column Chart 3D small column chart 3D

The stacked bar chart stacks bars that represent different groups on top of each other. The height of the resulting bar shows the combined result of the groups. It uses the input data set as follows: 

  • The first column contains the various categories to be compared. They are shown along the X-axis.
  • The values in the following columns, represented by different colors, combine the values of the groups.

Bar Chart In Rows small bar chart in rows

This three-dimensional chart it is very similar to the stacked column chart, with the difference that the values are displayed in distinct vertical bars. The following input data set is used:

  • The first column contains the names of the rows in the chart. These are the different categories to be displayed.
  • The values contained in each of the following columns will be represented by vertical bars on the various rows in the chart.

Stacked column chart (%)

This chart illustrates various distributions of values as a series of vertical bars that are the same size, but have different compositions. It uses the input data set as follows:

  • The first column contains the various cases for which the values are to be compared. They are shown along the X axis. There is a bar for each row in the data set.
  • The values in the following columns are represented by the sections in the vertical bar.

Gauge charts

Gauge chart small image half gauge and Gauge chart 2 small image full guage

Gauge charts use needles to show information as a reading on a dial. This chart type is often used in executive dashboard reports to show key business indicators. Gauge charts are useful for comparing values between a small number of variables either by using multiple needles on the same gauge or by using multiple gauges:

  • Only one row is processed.
  • The first column establishes the relationship between the various values. Its content (a text label) is shown above the graph.
  • The values of the following columns will be represented as needles on the gauge.

Horizontal Gauge Chart and Vertical Gauge Chart  small image vertical gauge chart

These charts let you compare a number of values shown as horizontal or vertical gauges. They use the input data set as follows:

  • The first column contains the gauge labels.
  • Each of the following columns contains the values that will be represented in the gauges.

Area and line charts

Bar and Line chart small image bar and line chart and Stacked Bar Line Chart small image stacked line bar chart

These charts track the evolution of a number of values displayed as a series of vertically aligned bars or vertically stacked bars or curves. The input data set is as follows:

  • The first column contains the various cases for which the values are to be compared. They are shown along the X-axis.
  • The values of the following columns are represented by a vertical bar or a point in a curve, depending on the setup.

Area Chart Line Chart small image line chart and Line Chart 3D small image line chart 3D

These charts track the evolution of a number of values displayed as curves. Area charts are like line charts, but the areas below the lines are filled with colors or patterns. The input data set is as follows:

  • The first column contains the various cases. They are shown along the X-axis.
  • Data in the following columns are represented as different-colored curves.

Area Chart (Time Axis) small image area chart Line Chart (Time Axis) and Line Chart 3D (Time Axis) small image line chart 3D time axis

These charts track the evolution in time of multiple values displayed as curves, using the input data set as follows:

  • The first column must contain dates, as it is used for the time axis (along the X-axis),
  • Data in the following columns are represented as different-colored curves.

Line and Line Chart small image line and line chart

These charts compare a number of variables with two different scales. These variables are displayed as curves using the input data set as follows:

  • The first column contains the various cases and are shown along the X-axis.
  • Data in the following columns is represented as different-colored curves.

Stacked Area Chart small image stacked area chart

This chart shows the evolution of the cumulative total of a number of values by stacking up the corresponding number of curves and coloring the included value areas. It uses the input data set as follows:

  • The first column contains the various cases for which the values are compared. They are shown along the X-axis.
  • The values in the following columns, represented by different colors, are totaled in the bar on the chart that corresponds to the row.

Stacked Area Chart (Time Axis) and Stacked Step Chart (Time Axis) small image stacked step chart time axis

These charts show the evolution over time of the total of a number of values by stacking the corresponding number of curves and coloring the included value areas. It uses the input data set as follows:

  • The first column must contain dates, as it will be used for the time axis (along the X-axis.)
  • The values in each of the following columns will generate a separate curve.

Pareto Chart small image pareto chart

Pareto charts help you to improve processes by identifying the primary causes of an event. A Pareto chart is a bar chart that ranks categories from the most frequent to the least frequent. These charts are frequently used for quality control data, so that you can identify and reduce the primary cause of problems.
Pareto charts include an accumulation line that shows the percentage of the cumulative total of all the columns or bars.

This chart requires a data set that satisfies the following criteria:

  • Two columns are required, the second of which must contain numeric values.
  • The first column contains the data labels.
  • The second column contains the data to be processed.

Pie and Bar Charts

Pie Chartsmall image pie chart Pie chart 3D and Donut chart

Pie charts are useful for highlighting proportions. They use segments of a circle to show the relationship of parts to the whole, using the input data set as follows:

  • The first column provides the labels of the different slices of the pie.
  • The chart uses the values of one of the following columns, the second by default.

Bar Chart small image bar chart Bar Chart 3D and Horizontal Bar Chart

Bar charts are useful for showing trends over time and plotting many data series.  This charts require a data set with the following criteria:

  • Only one row is processed.
  • The first column establishes the relationship between the various values. Its content (a text label) is shown above the graph.
  • The values in each of the following columns form one of the bars in the chart.

Pie Chart In Bar small image pie chart in bar

This chart illustrates various distributions of values with as many pie charts, whose heights represent their respective totals. It uses the input data set as follows:

  • The first column contains the labels of the pie charts' slices.
  • Each of the following columns matches a pie. The values are represented by the slices and their total by the pie's height.

Other charts

Table small image table

Displays the data as a standard or cross table.

Age Chart small image age chart

This chart shows an age pyramid based on the input data set as follows:

  • The first column contains the various tiers in the pyramid. They are displayed one above the other in the center of the pyramid.
  • The second column contains the values displayed on the left of the pyramid.
  • The third column contains the values displayed on the right of the pyramid.

Kiviat small image kiviat chart

This chart, also known as a spiderweb chart, compares the distribution of a series of variables among multiple axes, each axis having its own range of values. The data set must comply with the following criteria:

  • Each row represents a different axis. There must therefore be at least three rows.
  • The first column contains the labels for the various axes.
  • The second column contains the minimum value of the range of each axis.
  • The third column contains the maximum value of the range of each axis.
  • Data in the following columns will be represented as different-colored spiderwebs.

Radar chartsmall image radar chart

Radar charts integrate multiple axes into a single radial figure. For each figure, data is plotted along a separate axis that starts at the center of the chart.

This chart is a specialization of the Kiviat chart as all axes share the same range. It is not necessary to have two columns to define this range. The data set must comply with the following criteria:

  • Each row represents a different axis. There must be at least three rows.
  • The first column contains the labels for the various axes.
  • Data in the following columns will be represented as different-colored spiderwebs.

Bubble plot chart small image bubble plot chart

Bubble charts, like scatter charts, use data points and bubbles to plot measures anywhere along a scale. The size of the bubble represents a third measure. Bubble charts are usually useful for representing financial data.

In addition to its X- and Y-coordinates, the size of a dot can be varied in order to represent a third component. Such dots are referred to as "bubbles." This chart can be created using the input data set as follows:

  • Four columns are required, the first three of which must contain numerical values.
  • A bubble is generated for each row.
  • The first column contains the variable labels.
  • The second column contains the X-coordinates of the bubbles.
  • The third column contains the Y-coordinates of the bubbles.
  • The fourth column contains the sizes of the variables.

Color Table Chart small image color table chart

This chart displays data in table form, with slightly inclined column headings. It is produced using the input data set as follows:

  • The first column contains the row labels.
  • The second column contains the column labels.
  • The third column contains the data.

Gantt View Chart small image gantt view chart

A Gantt chart is a type of bar chart that illustrates a project schedule. This chart displays a Gantt diagram representing various tasks over time. You can view the details of a particular task by clicking on its bar. This chart requires a data set that satisfies the following criteria:

  • Each row defines a task.
  • The first column contains the task label.
  • The second column must contain a date that defines the start of the task.
  • The third column must contain a date that defines the end of the task.

Scatter Plot Chart small image scatter plot chart

Scatter charts use data points to plot two measures anywhere along a scale. Scatter charts are useful for exploring correlations between different sets of data. It is produced using the input data set as follows:

  • Three columns are required.
  • The first column specifies the variable to which the dot defined on the row belongs. Each value in this column corresponds to a different variable (and a different color), and there is a dot for each row in the data set.
  • The second column contains the point's X-coordinate.
  • The third column contains the point's Y-coordinate.

Funnel chart small image funnel chart

Funnel charts are often used to represent stages in a sales process and show the amount of potential revenue for each stage. This type of chart can also be useful in identifying potential problem areas in an organization’s sales processes. A funnel chart is similar to a stacked percent bar chart.

This chart requires a data set that satisfies the following criteria:

  • The first column establishes the relationship between the various values. Its content (a text label) is shown above the graph.
  • Values in each of the following columns will be represented in ascending order from the bottom.

Map Chart small image map chart

This displays one of the available maps and visually highlights the weights of its constituent areas for a particular variable. The data set must comply with the following criteria:

  • The first column contains the codes representing the areas on the map.
  • The second column must contain a numerical value. This value will be represented by the area's color level.

Related Links