Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart Axis Reversal
In article ,
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
x axis labels/scale move to middle of chart w/neg & pos line cht | Excel Worksheet Functions | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
make line in chart start at y axis | Charts and Charting in Excel | |||
how to show date on the x axis of a line chart? | Charts and Charting in Excel | |||
Problems with X Axis for a Line Chart | Charts and Charting in Excel |