The Multiple Line Chart displays data of one series, separated into different lines:
Multiple Line Charts can also be achieved with the Line Chart, however, the Line Chart expects the data for each line to be in a separate column, which might not be the case with your data. E.g., if your data source consists of revenue data, with date, company, revenue amount, etc., there would usually not be a column for each company, but rather a column Company which then has the different company names in it. So, the data would need to be transformed in order for each company to have its own column; hence the Multiple Line Chart can handle this case better, as it will be explained in the next section.
Expected Data and Graph Designer
The Multiple Line Chart expects data in a three-column format, with the x-axis value as the first column, the line name as the second column, and the value of the line as the third column (just like the Stacked Bar Chart):
|Month & Year||Company||Revenue|
So there needs to be a row for every x-axis value and corresponding line.
Therefore, new lines can simply be added by adding a new row with the line's data for the corresponding x-axis value.
This required format can be achieved in SQL with a GROUP BY statement which groups by the x-axis value and the line name and forms the sum of the line value.
The selection of the x-axis in the Graph Designer does not have an effect.