Line chart

    A line chart displays a change to one or more measures over a time interval. It indicates trends, seasonality, dynamics, and a ratio of multiple measures at a single point in time.

    It can show multiple measures with different lines.

    line_chart

    For example, you can display the basic sales targets, gaming performance trends, or app usage statistics as dotted, dashed, or solid lines.

    1. Open the All workbooks overview page and select your workbook.

    2. Open the dashboard to which you want to add a chart.

    3. In the upper-right corner, click Edit.

    4. Click AddChart (Wizard). You'll see the chart creation wizard.

    5. On the top left, select the Dataset you want to visualize.

    6. Click the chart type field on the right of the dataset section and select Line chart from the drop-down menu.

    7. Drag and drop Measures and Dimensions to the appropriate sections of the chart (see the Data fields tab).

      Your chart creation wizard should look similar to the following:

      line_chart-wizard

    8. Click Save in the upper-right corner of the page.

    9. Name your chart and click Done.

    10. Choose the appropriate location for your chart by dragging it around the dashboard and resize it by dragging the lower-right corner of its frame.

    11. Click Save in the upper-right corner of the page.

    Wizard slot Description
    X Dimension.
    Y Measure. Multiple-field slot.
    If you add more than one field to this slot, the Measure Names field will appear in the Colors slot.
    Y2 Measure. Multiple-field slot.
    If you add more than one field to this slot, the Measure Names field will appear in the Colors slot.
    Colors Dimension or Measure Names. Affects line colors.
    You can add a Measure Names or Measure Values field to this slot.
    You can delete the Measure Names field by removing fields from the Y and/or Y2 slots.
    Shapes Dimension or Measure. Affects the line shapes.
    Sorting Measure. Measures from the x-axis. Affects the sorting of the x-axis.
    Signatures Dimension or Measure. Shows dimension values on the chart. You can add a Measure Names or a Measure Values field to this slot.
    Split Measure as a category. Separates a single chart into multiple by category.
    Chart filters Dimension or Measure. Used to filter values. You can add a Measure Names or Measure Values field to this slot.

    To open chart settings, click to the right of the chart type above the wizard slot fields. You'll see a dialog window with the following controls:

    Control Default state Description
    Header On Displays the specified text in the centered line above the chart.
    Legend On Displays the field name associated with color line below the chart.
    Sum in tooltips On Displays the sum of the values of all the lines on data point hover.
    Navigator Off Displays the Navigator for selected lines below the chart.
    Labels overlap Off Allows the labels with a large amount of text to overlap.
    Use with caution - this may negatively affect the labels readability.

    After managing the controls, click Apply to see the results on the chart preview.

    To open wizard slot settings, click in a row with the slot name. Depending on the slot, you'll see a dialog window with the following controls:

    X and Y axes:

    Setting Description Possible values
    Axis title Sets an axis label. Auto: Uses a field name. If the section contains several fields, Visualization uses the name of the field added to the list first.
    Manual: Allows you to enter an axis title manually.
    Off: Axis will have no label.
    Axis type Sets the axis type. The setting is available for fields in the axis section that have the Fractional number type. Linear: Sets a linear axis type.
    Logarithmic: Sets a logarithmic axis type, preferable for charts with a wide range of values. A logarithmic axis allows you to display a fast-growing graph in a convenient form for analysis, reducing values by order of magnitude.
    Grid Displays a grid on the chart. On: Displays the grid.
    Off: Hides the grid.
    Grid step Sets the grid spacing in pixels. Auto: Sets the grid size automatically.
    Manual: Allows you to set the grid size in pixels.
    Labels Displays data field labels on the chart. On: Displays labels.
    Off: Hides labels
    Labels view Sets the appearance of the label display. The setting is available if the Labels setting is set to On. Auto: Positions label values automatically.
    Horizontal: Positions label values horizontally.
    Vertical: Positions label values vertically.
    Angle: Displays label values at a 45-degree angle.
    Empty values (null) Specifies how to process empty values.
    Not supported by Scatter chart.
    Ignore: Doesn't display empty values in a chart.
    Connect: Joins values of fields that have empty values between them.
    Display as 0: Displays empty values in charts as zero (0) field values.
    Scaling Sets the scale of chart axes. Auto: Sets the scale automatically. You can specify how Visualization sets the scale: from the minimum to the maximum field values (Autoscale from min to max) or from 0 to the maximum field value (Autoscale from 0 to max).
    Manually: Allows you to set the axis scale manually. You can set the maximum and minimum values along the axis. Visualization trims the chart lines by this value.

    Colors:

    On the left, you can select a line from a data source in the Colors slot of your chart.

    On the right, you can select a color scheme and a color for the line. Select AUTO to let Visualization do the coloring for you.

    Shapes:

    {% include settings-shapes.md %}

    After managing the controls, click Apply to see the results on the chart preview.

    • To highlight the trends a line chart displays, lower its width on your dashboard.

    • When visualizing multiple measures, give a thought to which colors you select for them. For better readability, choose contrasting and easy-to-distinguish colors:

      line_chart-hint-colorize

      We recommend you use three to five colors per chart.

      If you want to draw particular attention to one certain line, highlight it in some bright color and tone down the colors of the other lines on the chart:

      line_chart-hint-color

      You can also use the Shapes settings to change the style of the line you want to emphasize.

    • To display the values for each data point, drag Measure values to the Signatures section:

      line_chart-hint-labels

    • If the lines on your chart represent different entities, toggle the Sum in tooltips in the chart settings to the Off position - this way, you won't get confusing results in the pop-up window on data point hover.