Line Chart

Line Chart

Overview

Line charts connect the series of data category data points using a line.

Example

SQL: 

SELECT AMOUNT, SOLD_ON as MONTH, ITEM FROM ITEM_SALES where YEAR(SOLD_ON) = 2019

 

Now you will prepare your result set as shown in Data Preparation so that you have the SOLD_ON (MONTH) column sort as a month of the year.

image-20250906-142002.png

Click the create a chart button  to display the Create Chart dialog. Now you will select the appropriate columns to use for the chart. In this example the value will be amount and the category will be month.

image-20250906-142007.png

After clicking Create Chart, the line chart will be displayed.

image-20250906-142015.png

No Legend

image-20250906-142021.png

Legend

image-20250906-142028.png