View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] ian.tiesdell@hotmail.co.uk is offline
external usenet poster
 
Posts: 1
Default Swapping X and Y Axis - line Chart

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