If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom Line Graph on 2 axes help | nevs | Charts and Charting | 4 | October 27th, 2005 03:29 PM |
x axis labels/scale move to middle of chart w/neg & pos line cht | rak | Worksheet Functions | 1 | August 30th, 2005 03:51 PM |
line chart | Randy K. | Setting Up & Running Reports | 3 | November 19th, 2004 03:20 AM |
Is it possible to plot this kind of data in a (line) chart w/ preferred axis? How? | pgtr | General Discussion | 4 | September 15th, 2004 02:05 AM |
changin X axis value in a line chart | Rejean Chamberland | Charts and Charting | 3 | December 4th, 2003 12:06 PM |