| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I make the x axis data the y axis data?
My graph automatically makes certain data the y axis and other data the x
axis. I need to just reverse it for the graph I am looking for. Any suggestions? |
|
#2
|
|||
|
|||
|
SLG,
One option is to reverse the positions of the data on the spreadsheet. Assuming an XY chart, you would change a setup like this: x y 5 4 4 2 5 3 7 4 6 5 to this: y x 4 5 2 4 3 5 4 7 5 6 If this doesn't work, can you post back to let us know what type of chart and data you're using? ---- Regards, John Mansfield http://www.pdbook.com "SLG" wrote: My graph automatically makes certain data the y axis and other data the x axis. I need to just reverse it for the graph I am looking for. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple x axis data | Charts and Charting in Excel | |||
| Shuffling Data To Make Lists Match | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| space between y axis and data points.. | Charts and Charting in Excel | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Linear Mode
