Line chart with 3 set values for Y-axis

Hi Anonymous,

From your description, it seems that you already put the Column2 in chart X axis, Column1, Column3 and Column5 as chart values. You can drag Column2, Column4 and Column6 in the chart Values bucket as well. 

I guess you want to ask why original lines for Column1, Column3 and Column5 are almost the same. This is due to the maximum value of these six columns is 22.40 which in Column6, so the chart Y axis range is 0 ~ 22.40 to display all values. As Column1, Column3 and Column5 values are almost the same and around value 2, but other three lines value are almost more than 10, the Column1, Column3 and Column5 lines are very close to looks like one line, but it's three lines actually. This is expected. 

Best Regards,
Qiuyun Yu