ExcelBanter - How do I make the x axis data the y axis data?

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/14523-how-do-i-make-x-axis-data-y-axis-data.html)

Sarah G

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?

Markus Scheible

Hi Sarah,

you can change the Source data of the chart by right-
clicking it. There you can define the columns / rows for
the x- and the y-axis.

Best

Markus

-----Original Message-----
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.