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

RM Batcha wrote:
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, Microsoft MVP - Excel
http://www.andypope.info