View Column, Line, Area, or Bar charts in an embedded worksheet

To view a column, line, area, or bar chart, select a standard worksheet for which the report type = pivot_editor, report source = Embedded, and the rv_chart_number is 1, 2, 4, or 5.

The chart is displayed in the available area below the pivot table, based on the value specified for the rv_pivot_size (pivot table size in pixels) parameter. If a value is not specified, the display area of the pivot table and the chart is equal.

Display settings:

  • In a multi-panel worksheet, if the area of the panel is less than the value of the rv_min_chart_size parameter, the chart is not displayed. However, if the parameter is not defined, the default value 0 is considered to display the chart.
  • If the pivot table is not included in the worksheet (rv_pivot_hide = TRUE), the entire worksheet panel area is used to display the chart.
  • The Y-axis of the chart is fitted to the available height. The X-axis is fitted to the width of the worksheet panel, unless the rv_fit_panel = FALSE and rv_chart_3D = FALSE. In this scenario, the default width for each category is used and a scroll bar is displayed which allows you to view all the categories.
  • If rv_chart_3D = TRUE, the chart fits the X-axis to the worksheet panel, irrespective of the rv_fit_panel setting.

Display of data in the rows:

  • If the rv_chart_rows = TRUE, by default, the chart plots the data in the rows.
  • A series (column, line, area, or bar) for each left dimension combination (Left 1 to n) is displayed. The pie charts display a segment based on the combination of each left dimension.
  • For each top dimension combination (Top 1 to n), a category label is displayed. The pie charts display a separate pie for each top dimension.
  • If the rv_chart_rows = FALSE, the series is based on the top dimensions (one for each combination). The category labels are based on the left dimensions.

Display options:

  • If rv_chart_3D = TRUE and rv_chart_number is 1 or 5 the chart is displayed in 3D.
  • If rv_pivot_hide = true, by default, the chart is displayed in the slicers area. To hide the dimensions in the slicer area, the user must specify the required data in the rv_slicers_hide parameter.

    Measures that are formatted as percentage values are displayed on a separate axis:

    • The values are plotted as the corresponding % value (75% and not 0.75).
    • If measures are defined with secondaxis = TRUE, the chart also displays a third axis (primary, % format, and the alternate axis), in addition to the % format measures.
      Note: These values are not applicable for pie charts.

    Area Charts (chart type = 4):

    • These charts are used to draw the series in a descending order based on the average value. Consequently, the largest series is drawn in the background, with smaller series in the foreground. All other chart types are drawn in the order of the elements (sort order of each specified dimension) in the pivot.
    • If rv_stacked_type = 1 (Stacked = TRUE) and rv_chart_type = 4 (Area chart), the standard order of drawing a series, based on the display order of the series in the pivot and the dimensions, is used. The series are stacked and displayed 'one on top of the other'.
    • When using multiple chart types, the order of area, column, or line must be used to draw the charts to move the data from the background to foreground. This ensures that each chart type is displayed in the panel.

    A legend is used to display the details of each series and the corresponding color code:

    • The position is set based on the value of the rv_legend_position parameter. By default, the details are displayed to the left of the chart. If rv_legend_position = 5 (which is only applicable for pie and funnel charts) then the default value rv_legend_position = 1 is used.
    • The toggle (hide or show) options are displayed when you select a series.

To view the details of the current series, value, and axis category, move the pointer over a series. The value for all the series of the selected axis category are also displayed. However, if the rv_single_tooltip = TRUE, only the details of the selected series are displayed.

Navigation:

  • If the scenario can be edited, drag a series (column, line, area, or bar) on the chart to modify the values. Consequently, the values in the pivot table are also updated. These changes must be applied using the Recalculate option.
    Note: This option is not applicable for pie charts.
  • For measures in a multi-panel worksheet, you can select a series in the chart (that contain the links to the panel) to update the data on the other panels.
  • Use the graph_hide parameter, to remove the elements in a dimension that must not be displayed in the chart.