How to interchange datas of 'X' & 'Y' axes in a Line Chart

[Guest]

Column & Bar Charts juxtaposed to each otherin that 'X' axis in one chart
becomes'Y' axis in the other. Can't we do same with the Line Chart.

 

[Andy Pope]

Hi,

In order to swap a line chart you need to convert the chart type to
xy-scatter and then adjust the ranges being used for x and y values.

If the line chart currently has categorical data on the x axis you will
need to do a little more work to swap the axes.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy