Chart Properties: Data

Defines the chart type and the data to use in the chart.

PropertyDescription

Chart Type

Type of chart.

  • Pie—Represents item values as slices of a pie.

  • Bar—Represents an item’s value as the height of a rectangular bar.

  • Area—Highlights an individual item’s significance relative to other items.

  • Line—Highlights trends by drawing connecting lines between data points.

  • Stacked Bar—Graphically highlights an individual item’s comparative significance using rectangular bars.

  • Overlapped Bar—Graphically highlights the contribution of individual items, within categories, to the total value.

  • Floating Bar—Represents an item's values as the height of a rectangular floating bar.

  • Histogram—Displays frequencies of each category from categorical variables.

  • 100% Bar—Graphically highlights a category’s contribution to the total, using rectangular bars.

  • 100% Area—Highlights a category’s contribution to the total.

  • Stacked Area—Highlights an individual item’s significance to a total using enclosed polygons.

  • High Low Close—Represents high, low, and final values of an individual item over time.

  • Combo—Combines two types of charts. (Pie, Radar, and Area Radar charts do not support multiple data views.)

  • XY-Scatter-PlotCompares pairs of values.

  • Bubble—Compares sets of three values. Like a scatter chart with the third value displayed as the size of the bubble marker.

  • Radar—Plots data as a function of distance from a central point.

  • Polar—Specifies points as an angle and a distance from the origin. Often used for scientific purposes.

  • Candle Stick—A type of Hi-Lo-Open-Close chart that draws four series together as a candle bar.

  • Area Radar—Similar to Radar charts except that the are between the origin and the points is filled.

Function Type

Operation to perform on the data retrieved. Function types include: Summation, Average, Count, Minimum, and Maximum.

Y-Axis

Column to chart on the Y-axis. (If this is a combo chart, this is the Y-axis of the first chart.) Available columns include the expressions and numeric columns defined in the query, and the calculated fields defined in the report layout.

Y2-Axis

Combo charts only. Column to chart on the second chart’s Y-axis. Available columns include the expressions and numeric columns defined in the query, and the calculated fields defined in the report layout. If combo is not selected as the chart type, Y2-Axis is disabled.

X-Axis

Column to chart on the X-axis. Available columns include the columns defined in the query.

X-Axis Series

How to group rows on the chart. (Not applicable for Pie, Floating Bar, High Low Close, Bubble, Radar, Polar, or Area Radar charts.)

Upper Y-Axis Value

Floating Bar charts only. The column to chart on the upper Y-axis. Available columns include the columns defined in the query.

Bubble

Bubble charts only. The third value to compare in the bubble chart. Available columns include the columns defined in the query.

Point Label

Radar, Polar, and Area Radar charts only. How to group the point labels on the chart. Available columns include the columns defined in the query.

Multi-Charts Option

If you are creating more than one chart, select the type of chart to use for the first and the second chart. For example, you could create a Line chart over a Bar chart, or a Hi-Low chart over a Bar chart. If combo is not selected as the chart type, the Multi-Charts Option is disabled.