Line charts allow you to visualize change over a continuous range, such as time or distance. Visualizing change with a line chart allows for the overall trend to be displayed at once, and for multiple trends to be compared simultaneously.
Line charts are made up of a continuous Date or Number on the x-axis, and an optional Number on the y-axis.
The x-axis of a line chart displays a continuous variable such as time or distance, and the y-axis measures change over that continuous variable. When a date field is chosen for the x-axis, the dates will be binned, or aggregated, into time intervals. When a number field is chosen for the x-axis and each number appears in the table only once, no aggregation is necessary for the y-axis.
If the x-axis number field has values that repeat, an Aggregation method must be chosen. The aggregation method can be one of the following:
- COUNT—The number of times each unique category appears in the field.
Time aggregation options
Time aggregation, or binning, occurs automatically when a date field is chosed for the x-axis. Several options control the interval size and related settings applied to the binning.
Temporal data is binned into time intervals along the x-axis. A default interval size is chosen based on the temporal extent of the dataset and can be manually changed using the Interval Size.
Depending on the sparsity of the dataset and the time interval size chosen for binning, there may be bins that contain no data. Empty bins may be treated as zero when lack of data truly represents a value of zero (for example, no illnesses were reported in May or no rain was collected during a week span). It is not appropriate to assign a zero to a bin in which no data exists because none was collected (for example, no reading from a temperature gauge does not mean there was a temperature of zero).
There are three options available for dealing with empty bins.
- Treat them as zero (Treat as zero)—This is most appropriate when counting incidents, as no incidents counted likely means zero incidents took place.
- Interpolate neighboring values (Connect line)—Null values can be visually interpolated by connecting the line between the bins on either side of the empty bin.
- Break the line (Break line)—Leaves a blank space where an empty bin falls.
Time intervals may align to the first data point or to the last data point.
Align to first data point initiates binning with the earliest date and works forward.
Align to last data point initiates binning with the most recent date and works backward.
This is important to consider because the last bin created may be partially empty, which can give the misleading impression that there is a dip in the value or count during that time, when really the data collection began or ended during the span of that bin. To avoid bin bias, check the Trim incomplete interval option. This will remove the partially filled bin from the visualization:
Line chart series can be defined from one or more value fields on the y-axis or from one value field split into series by a second category field.
From one or more fields
Each line's marker corresponds to a numeric value. In a chart with a COUNT Aggregation method, no numeric value field needs to be specified because the value corresponds to how many unique records fall into each time interval. For example, in a dataset of crime incidents, a date field is binned into 2 week intervals with a COUNT Aggregation method. The resulting chart will display a marker for every 2 week interval representing how many crimes took place during those 2 weeks.
Other times, the numeric value corresponding to marker's placement will come from a field in the attribute table. This field can be specified in the Series table by selecting it from the Fields list. For example, in a dataset of crime incidents, a date field is binned into 2 week intervals with a SUM Aggregation method and a PropertyLoss Fields selected. The resulting chart will display a marker for every 2 week interval representing the sum of the PropertyLoss values that took place during those 2 weeks.
Additional Fields can be chosen to create a chart with multiple series. For example, in a dataset of crime incidents, a date field is binned into 2 week intervals with a SUM Aggregation method and two Fields selected, PropertyLoss and TotalDamage. The resulting chart will display two lines, one representing the sum of PropertyLoss and the other the sum of TotalDamage for every 2 week interval.
From one field split into series
A category field can also be used to make a line chart with multiple series. For example, in a dataset of crime incidents, a date field is binned into 2 week intervals with a COUNT Aggregation method and a CrimeType Split by field. The Series table will populate with each unique CrimeType (Theft, Vandalism, Arson) and the resulting chart will display three lines, each representing the total number of crimes of that type that took place during those 2 weeks.
You can modify the appearance of a line chart by specifying and formatting its title, description, axis titles, and series colors.
Titles and description
Charts and axes are given default titles based on the variable names and chart type. These can be edited on the General tab in the Chart pane. You can also provide a chart Description, which is a block of text that appears at the bottom of the chart window.
Line colors can be changed by clicking the Symbol color swatch in the Series table and choosing a new color.
Create a line chart to visualize trends in fire events in Naperville from 2007-2010.
- Date or Number— Date
- Aggregation— COUNT
- Time Interval Size— 3 Months
- Series > From one field split into series
- Number— <empty>
- Split by— Time of day