Line Chart Axis Reversal

[AdamP]

Hi all,
Wonder if you can help.
I have a line chart with no of stations or a distance along the x axis and
time along the y Axis. what ever i try including swapping the tables round
manually and creating a pivot table, i cannot get the axis to reverse, to
have distance on the Y axis and Time on the X axis. Any Help would be
gratefully recieved.
Regards

 

[Tushar Mehta]

Hi all,
Wonder if you can help.
I have a line chart with no of stations or a distance along the x axis and
time along the y Axis. what ever i try including swapping the tables round
manually and creating a pivot table, i cannot get the axis to reverse, to
have distance on the Y axis and Time on the X axis. Any Help would be
gratefully recieved.
Regards

Consider switching to a XY Scatter chart. It supports cardinal values
on the x-axis. Also, while not strictly necessary, it will make your
life a lot easier if the x-values are in a column to the left of the y-
values.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions