Line Chart Axis Reversal

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

In article <D6054413-B374-48CF-AF4A-FCC8D7C80337@microsoft.com>,
AdamP@discussions.microsoft.com says...
> 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