There is no need to duplicate the X values. Just put the Y2X
values in a different column from Y1. Create a chart from A1:C5. Edit the chart and select line chart if necessary.
- Just put the
Y2
values in a different column fromY1
. - Create a chart from
A1:C5
. - Edit the chart and select line chart if necessary.