Posted to microsoft.public.excel.charting
|
|
Swapping X and Y Axis - line Chart
http://www.peltiertech.com/Excel/Cha...egoryAxis.html
wrote in message
...
Hi
I have been asked if it is possible to swap the x and y axis over on a
line chart
i can find infor for doing this on a scatter but not on a line chart.
i have tried reformatting the data but this didn't work
i want the variable data values to be plotted on the horizontal axis
and the static values to be plotted on the vertical axis - i know i
can do this via a bar chart but this chart need to be a line chart
is this possible?
Ian
|