Chart Design View

The Chart Design View allows you to specify the type of chart, much like in Excel, you would like from the data in the underlying Pivot while seeing the chart update in real time as you slice and dice your data.

Chart Design Features

The chart design enables you to specify the type, series, legends, and totals that can be used in designing the chart itself.

The key factors are the chart type and series:

  • Type
    • Bar
    • Area
    • Line
    • Pie
    • Spline
    • Spline Area
  • Series
    • Rows
    • Columns

Chart Design Properties

A chart design has the following properties:

NameDescription
Series

The source of data for the series in the chart

  • Columns
  • Rows
Type

The type of chart

  • Area
  • Bar
  • Line
  • Pie
  • Splice
  • Splice Area
Combine Mode

The mode in which data is combined

  • None
  • Cluster
  • Stack
  • Stack100
Row Sub Total Position

The position of any row sub totals

  • None
  • Left
  • Right
Row Grand Total Position

The position of any row grand totals

  • None
  • Left
  • Right
Column Sub Total Position

The position of any column sub totals

  • None
  • Left
  • Right
Column Grand Total Position

The position of any column grand totals

  • None
  • Left
  • Right
Hide LabelsIndicates if automatic labels should be hidden from view, and just tooltips provided