Hi,

I'm trying to do a line chart, and show the monthly movement on the lines to
go from the top of the chart, down to the bottom, rather than left to right.
I cannot see how to achieve this, I think it may be a case of transposing
axis around but am not sure? - can anyone help.

Hi,

In order to have lines go up/down rather than left/right you need to use
the xy-scatter chart.

Stephen Bullen has an example, FunChrt2.zip
http://www.oaltd.co.uk/Excel/Default.htm

Cheers
Andy

Marky Mark wrote:
Hi,

I'm trying to do a line chart, and show the monthly movement on the lines to
go from the top of the chart, down to the bottom, rather than left to right.
I cannot see how to achieve this, I think it may be a case of transposing
axis around but am not sure? - can anyone help.

--

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