- Line / Area Example

Line / Area Example

A line chart is a chart of connecting points that show changing quantities over time. Each data node represents its respective magnitude or quantity at that point of time, while each line represents a single data group. A multi-series chart compares two or more groups of data against each other.

An area chart displays graphically quantitative data; it emphasizes a change in values by filling in the portion of the graph beneath the line connecting various data points. It is commonly used as a multi-series chart where an area chart is compared with two or more quantities.

We will now create a line chart to illustrate how many employees the company has hired since its opening. We will be using the following SQL statement:

SELECT hiredate, SUM(employeeid) FROM dillsample.employee GROUP BY hiredate

An area chart would have the same SQL format and the resulting graph would be similar with difference being that the area beneath the graphed line will be shaded in.