Line chart with 3 set values for Y-axis

[Anonymous]

Hi everyone,

Can I put 3 sets value of Y-axis in the line chart? I have try to put them in the chart, but it change to the same vaule of Y-axis.

Can anyone could help me, thanks so much!!!

[v-qiuyu-msft]

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 

[Anonymous]

@v-qiuyu-msftoh my god, let me try again, thanks so much^^