Spotfire® User Guide

Line chart

A line chart is used for showing trends, and in most cases trends over time. It can also be used for discerning certain patterns.

A standard example would be how the stock value for a certain company develops over time on the stock market. However, it does not necessarily need to be time along the X-axis. Any data that behaves like a function with respect to the variable on the X-axis can be plotted. Line charts emphasize time flow and rate of change rather than the amount of change.

The main axes in the line chart are the X-axis and the Y-axis. To show trends over time, select a time column on the X-axis. For each data point on the X-axis, Y-axis values are placed. These values can represent aggregated data or non-aggregated data for the particular data point. An aggregated value could be, for example, a sum or an average. To draw the "full" line, straight lines are then drawn between these values.

You can adjust the scales and scale labels, as well as other axis settings, from the visualization properties for each axis, and you can add features such as gridlines, zoom sliders or error bars, and so on.

Example

Below is a line chart showing the sum of sales for two different product categories over several years. The line chart has one color (one line) per product category.

When several different years are available it may also be useful to trellis the data by year to display the variation during the years separately:

All visualizations can be configured to show data limited by one or more markings in other visualizations only (details visualizations). Line charts can also be limited by one or more filterings. Another alternative is to configure a line chart without any filtering at all. See Adding data limitations for a visualization for more information.

You can show data from multiple data tables in the same visualization if a proper data table matching is available. For more information, see Multiple data tables in one visualization and Column matches.