Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

There are a number of chart types to choose from to best represent your information, including:

  • Column: compares values displayed as columns. 

  • Bar: compares values displayed as bars. 

  • Line: compares values displayed as points connected by lines. 

  • Area: compares values displayed as shaded areas. 

  • Spider: compares three or more values on a series of spokes. Spider charts can use columns, lines, or areas to display values. 

  • Dual and Multi-Axis: display values using two or more measures. 

  • Time Series: compares time intervals displayed as points connected by lines. 

  • Scatter: compares values as individual points arrayed across both axes of a chart. 

  • Bubble: compares three measures displayed as circles of varying sizes arrayed across both axes of a chart. 

  • Pie: compares values displayed as slices of a circular graph. 

  • Range: displays values as heat maps. 

By default, the Ad Hoc Editor creates a column chart. You can select a different type of chart at any time.
To select a new chart type, complete the following steps:

  1. In the  Ad Hoc View panel, click the  Detail Selector icon  to show the  Canvas Options context-menu. 

  2. Select  Chart Types from the context-menu. The  Select Chart Type window appears. 

  3. Click the type of chart you want to apply to your report. The selected chart type is outlined in blue. 

  4.  Leave the  Select Chart Type window open to rapidly switch between chart types, or click the  Close icon   at the top right to close it.  

The following table describes the available chart types, and any rules affecting their usage (where required):
 

Icon
Description
Rules
Column ChartsColumn charts compare values displayed as columns 
Image Removed

Image Added

Column. Multiple measures of a group are depicted as individual columns. 
Image Removed

Image Added

Stacked Column. Multiple measures of a group are depicted as portions of a single column whose size reflects the aggregate value of the group. 
Image Removed

Image Added

Percent Column. Multiple measures of a group are depicted as portions of a single column of fixed size. 
Image Removed

Image Added

Spider Column. Multiple measures of a group are depicted as portions of individual "columns" along a spoked chart. 
Bar ChartsBar charts compare values displayed as bars 
Image Removed

Image Added

Bar. Multiple measures of a group are depicted as individual bars. 
Image Removed

Image Added

Stacked Bar. Multiple measures of a group are depicted as portions of a single bar whose size reflects the aggregate value of the group. 
Image Removed

Image Added

Percent Bar. Multiple measures of a group are depicted as portions of a single bar of fixed size. 
Line ChartsLine charts compare values displayed as points connected by lines 
Image Removed

Image Added

Line. Displays data points connected with straight lines. 
Image Removed

Image Added

Spline. Displays data points connected with a fitted curve. 
Image Removed

Image Added

Spider Line. Displays data points connected with straight lines on a spoked chart. 
Area Charts  
Image Removed

Image Added

Area. Displays data points connected with a straight line and a color below the line; groups are displayed as transparent overlays. 
Image Removed

Image Added

Stacked Area. Displays data points connected with a straight line and a solid color below the line; groups are displayed as solid areas arranged vertically, one on top of another. 
Image Removed

Image Added

Percent Area. Displays data points connected with a straight line and a solid color below the line; groups are displayed as portions of an area of fixed sized, and arranged vertically one on top of the another. 
Image Removed

Image Added

Area Spline. Displays data points connected with a fitted curve and a color below the line; groups are displayed as transparent overlays. 
Image Removed

Image Added

Spider Area. Displays data points connected with straight lines and a solid color between the line and the center of a spoked chart; groups 
are displayed as transparent overlays.
 
Dual and Multi-Axis ChartsYou can compare two or more measures, using one charting time or multiple charting types, with the charts listed here 
Image Removed

Image Added

Column Line. Displays leftmost measures as bars, last measure as a line.
  • Requires two or more measures. Measures must be placed in the Columns location.

  • Fields and dimensions can only be placed in the Rows location.

Image Removed

Image Added

Stacked Column Line. Displays leftmost measures as stacked bars, last measure as a line.
  • Requires three or more measures.

  • Measures must be placed in the Columns location.

  • Fields and dimensions can only be placed in the Rows location.

Image Removed

Image Added

Column Spline. Displays leftmost measures as bars, last measure as a spline.
  • Requires two or more measures.

  • Measures must be placed in the Columns location.

  • Fields and dimensions can only be placed in the Rows location.

Image Removed

Image Added

Stacked Column Spline. Displays leftmost measures as stacked bars, last measure as a line.
  • Requires three or more measures.

  • Measures must be placed in the Columns location.

  • Fields and dimensions can only be placed in the Rows location.

Image Removed

Image Added

Multi-Axis Line. Displays each measure as a separate axis line.
  • Requires two or more measures.

  • Measures must be placed in the Columns location.

  • Fields and dimensions can only be placed in the Rows location.

Image Removed

Image Added

Multi-Axis Spline. Displays each measure as a separate axis spline.
  • Requires two or more measures.

  • Measures must be placed in the Columns location.

  • Fields and dimensions can only be placed in the Rows location.

Image Removed

Image Added

Multi-Axis Column. Displays each measure as a separate axis column.
  • Requires two or more measures.

  • Measures must be placed in the Columns location.

  • Fields and dimensions can only be placed in the Rows location.

Times Series ChartsTimes Series charts illustrate data points at successive time intervals 
Image Removed

Image Added

Line. Displays date and time data points connected with straight lines.

  • Requires a single date/time field in the Rows location.

  • Field must be set to the "day" group function.

Image Removed

Image Added

Spline. Displays date and time data points connected with a fitted curve.

  • Requires a single date/time field in the Rows location.

  • Field must be set to the "day" group function.

Image Removed

Image Added

Area. Displays date and time data points connected with a straight line and a color below the line; groups are displayed as transparent overlays.

  • Requires a single date/time field in the Rows location.

  • Field must be set to the "day" group function.

Image Removed

Image Added

Area Spline. Displays date and time data points connected with a fitted curve and a color below the line; groups are displayed as transparent overlays.

  • Requires a single date/time field in the Rows location.

  • Field must be set to the "day" group function.

Scatter ChartsScatter charts show the extent of correlation between the values of observed quantities 
Image Removed

Image Added

Scatter. Displays first measure as the x-axis, the second measure as the y-axis. Other fields and dimensions in the column group become data points.
  • Requires exactly two measures.

  • Measures must be placed in the Columns location.

Bubble ChartsBubble charts show the correlation between three measures, displayed as disks 
Image Removed

Image Added

Bubble. Displays first measure as the x-axis, the second measure as the y-axis, and the third measure determines the size of the disk.

 
Pie ChartsPie charts display values as slices of a circular graph 
Image Removed

Image Added

Pie. Multiple measures of a group are displayed as sectors of a circle.

 
Image Removed

Image Added

Dual Pie. Multiple measures of a group are displayed as sectors of concentric circles.

 
Image Removed

Image Added

Semi-Pie. Multiple measures of a group are displayed as sectors of a half-circle. 
Range ChartsRange charts display values heat maps 
Image Removed

Image Added

Heat Map. Individual values represented as colors.

  • One field, followed by one Measure, required in the Columns location.

  • One field required in the rows location.

Image Removed

Image Added

Time Series Heat Map. Individual values across dates/times represented as colors.

  • One Measure required in the Columns location.

  • One Date/Time field required in the Rows location.

Image Removed

Image Added

Dual Measure Tree Map. Displays data as color-coded rectangles; the size of each rectangle is proportional to the first measure and the color represents the second measure.
  • Two Measures required in the Columns location.

  •  

      One One field required in the Rows location.

Image Removed

Image Added

Tree Map. Displays data as rectangles; the size of each rectangle is proportional to the measure of the data it represents. The tree map displays nested rectangles when you have more than one field; the parent rectangle represents the leftmost measure while the nested rectangles represent the current level of aggregation. Click on a parent rectangle to drill down to the nest rectangle.
  • One Measure required in the Columns location.    

     

  • One or more fields required in the Rows location.

Image Removed

Image Added

Parent Tree Map. Displays data as nested rectangles; the size of each rectangle is proportional to the measure of the data it represents. The nested rectangles represent the current level of aggregation while the larger rectangle represents the parent level in the hierarchy. Click on a parent rectangle to drill down to the nest rectangles.
  • One Measure required in the Columns location.  

     

  • Two or more Fields required in the Rows location.