'Spire.XLS use single value to create a line in a chart

I'm using Spire.XLS to make a project where some charts are displayed using values from a different sheet, and I'm trying to find out if I can create a line that crosses the chart from start to end but only using 1 or 2 values, while there are more steps in the category axis, for example I have a 6 steps X Axis and then 2 values that I want to make a line off on the X axis, can I like set up the 2 value to be relative to the first and last step or I only need to have 6 of those values as well?chart

For example in this case I want the red line to cross the entire chart instead of stopping at the second step of the chart, do you have some advices? I could like copy and paste the column with the values of the red line for 6 column straight but in that case is pretty awful to see and not really efficient



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source