Use Chart Designer

Pentaho Business Analytics
Version
10.1.x
Audience
anonymous
Part Number
MK-95PDIA004-17
After defining the data for the new chart with the Query Editor, you are ready to create the visual layout for the chart using the Chart Designer.

This part of the tutorial assumes you have followed the steps in Use Query Editor to define the data for the examples shown in the following steps

  1. In Chart Designer, under Data, click the drop-down arrow to display the data selection menu:

    Data panel
    Data Field Description
    Series Column Series display as the individual columns on a bar chart and as individual lines in a line chart. Area charts display each series as a point.
    Category Column Categories display as bars or groups of bars on the x-axis (horizontal axis). In line charts, categories are usually associated with time periods. In area charts, the x-axis displays the category labels. If you do not want to display categories, choose None.
    Values Column The value determines the height of columns in a bar chart and the height of lines in a line chart. In area charts, the y-axis values determine the heights of the points. The value is always numeric.
    A preview of the chart appears in a box in the upper-right corner of the Chart Designer as you select your options.

    Chart designer preview
  2. Under Chart Type, click the type of chart applicable for your data. If you are unsure which chart type is best for displaying your data, see Chart types for more information. In this tutorial, Bar Chart is selected.
    By default, pie and dial charts display in animated Flash mode. You can turn animation off by disabling the Animated check box in the Chart Designer. Animated charts can highlight key data points. For example, you may want to apply animation if a data point reaches a critical value, such as high or low sales numbers. If you selected a pie or dial chart, see Pie charts or Dial charts.
  3. Under Theme, select a theme from the list. In this tutorial, the Default theme is selected.
    The theme is applied to your chart.
  4. Enter the labels for the Chart Title, X Axis Title (horizontal axis), and Y Axis Title (vertical axis).
    Entries appear in the chart preview.
    Chart preview x and y axis
  5. Click Apply to see the chart preview.
  6. Click OK to display your chart in the dashboard panel.
The revised chart now appears in the dashboard.