Multiple Style Chart

Chart Properties for the Show Points option for Line Chart and Radar Chart.

You can assign distinct styles (e.g., line, bar, point) to individual measures on a chart.

What is a measure?

A measure is generally used for aggregation, for example summation, averaging, correlation, etc., within a Crosstab, Chart, Text component, or Gauge. Adding a measure to the ‘Y’ region in a chart displays the computed aggregates by using locations on the Y-axis. Adding a measure to the ‘X’ region displays the computed aggregates by using locations on the X-axis. You can also display aggregates by using color, shape, size, or label.

multiple style chart example

To create such a multiple-style chart, follow the steps below:

If you are new to charting, see the following sections first:

Configure Your Data…​

The data source for the chart (data block or data model) should represent dimensions and measures as independent columns or fields, as shown below. See Prepare Your Data for information on how to manipulate your data, if it is not currently in this form. (Note: A properly designed data model will already have the correct structure.)

data source with dimensions and measures as columns

In some cases (e.g., Pie Chart), you may want your data to provide just a single measure. In other cases (e.g., Line Chart), you may want the data to supply multiple measures. If the data does not provide the correct number of measures, you may be able to alter the number of measures to suit the needs of the chart by “pivoting” or “unpivoting” the data. See Pivot Data in Prepare Your Data for more information about this procedure.

Open a Chart for Editing…​
Watch Video: Create a Chart (Open the Chart Editor)

This video might show an earlier version of the feature or operation that differs in minor ways from the current version.

Follow the steps below to get started with a new Chart. See Basic Charting Steps for more details.

  1. If necessary, create a new Dashboard. (See Create a New Dashboard.)

  2. From the Toolbox panel, drag a Chart component into the Dashboard.

    drag Chart component into Dashboard

  3. Resize the Chart as desired by dragging the handles.

    drag handles to resize Chart

  4. Press the ’Edit’ button in the center of the Chart or press the ‘Edit’ button Edit in the top-right corner.

    press Edit button on Chart

    This opens the same Visualization Recommender available for creating a new Dashboard. (See Create a New Dashboard.)

  5. To bypass the Recommender, press the ‘Full Editor’ button Full Editor at the top right to open the Chart Editor.

    press Full Editor to open Chart Editor

  1. Create a Chart with multiple measures. See Multiple Measure Chart for more information.

  2. Press the ‘Select Chart Style’ button Select Chart Style.

    press Select Chart Style button

  3. In the chart styles panel, enable the ‘Multiple Styles’ option (below the chart style options), and press ‘Apply’ button Apply.

    enable Multiple Styles option in chart styles panel

  4. Press the ‘Select Chart Style’ button Select Chart Style next to the measure you wish to change.

    press Select Chart Style button next to a measure

    This opens the chart styles panel for the specified measure.

    chart styles panel open for individual measure

  5. Click a chart type to select it, and then press the ‘Apply’ button Apply. (You can also double-click the desired chart type.) This applies the style individually to the specified measure.

    Only compatible style combinations can be selected. (For example, ‘Pie’ and ‘Line’ are not compatible styles, and cannot be selected together.)

  6. Press the ‘Finish’ button Finish to close the Editor.

  7. To change the visual appearance (color, shape, size) of the measures independently, expand the menu in the Visual panel and select the measure you want to modify (or press the ‘Previous’ button Previous or ‘Next’ button Next to cycle through the measures). Select ‘all’ to modify all measures. Then press the desired the ‘Edit Color’, ‘Edit Shape’, or ‘Edit Size’ buttons.

    expand Visual panel menu to select measure for styling

You can proceed to edit the titles, legend, etc. See Basic Charting Steps and Chart Properties for more information. See Add Data Format for information on how to format text on a Chart.

Explore More…​

The sample Executive Sales Summary Dashboard provides an example of a multiple style chart (Bar and Line together).

Executive Sales Summary multiple style chart dashboard

To explore this sample Dashboard, download and import the Executive Sales Summary Dashboard into your environment. (This requires access to Enterprise Manager.) See Import and Export Assets for instructions on how to import.