XY Line Chart
Overview
Line charts connect the series of data category data points using a line. The XY Line chart allows you to pick a numeric value for the X axis, for instance a year instead of a character based value.
Example
SQL:
SELECT AMOUNT, SOLD_ON as YEAR, ITEM
FROM ITEM_SALESNow you will prepare your result set as shown in Data Preparation so that you have the SOLD_ON (YEAR) and ITEM columns sorted ascending as shown.
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 sum, the category will be year and the legend will be item.
After clicking Create Chart, the line chart will be displayed.