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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RM Batcha - 31 Aug 2006 07:31 GMT

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.

Reply to this Message

Andy Pope - 31 Aug 2006 08:39 GMT

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

> 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.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message