ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I make the x axis data the y axis data? (https://www.excelbanter.com/charts-charting-excel/14524-how-do-i-make-x-axis-data-y-axis-data.html)

SLG

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?

John Mansfield

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?



All times are GMT +1. The time now is 09:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com