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

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.

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

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