Line Chart Axis Reversal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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
 
Back
Top