Ask Your Question

How do I switch the X and Y axes in a Calc Chart? [closed]

asked 2013-04-23 18:06:32 +0100

DataHolic gravatar image

updated 2013-06-16 18:08:15 +0100

manj_k gravatar image

I'm a little surprised at how long it's taken me to figure out something that I would think is pretty easy to do... When I make a chart the X axis has a total number from column B and the Y has a percentage from column A.

How do I switch these two? In other words, how do I associate the data in column A with the X axis and the data from column B with the Y?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 07:36:54.297180

1 Answer

Sort by » oldest newest most voted

answered 2013-04-23 18:39:34 +0100

Pedro gravatar image

Any spreadsheet expects the first column to be X and the second Y.

That said, just right click on the chart, click on Data Ranges, Click on the Data Series tab and then change the ranges for the X-values and Y-values. You can manually edit or click on the button to the right to select it with the mouse.

edit flag offensive delete link more


I made a chart a while back, but realized that it would be easier to read with the axes switched. I found a pretty easy way to do it that did not have anything to do with Data ranges - I made a new sheet in the same document, highlighted the data I wanted to switch, copied, and used paste special in the new sheet. In the options under "paste special" there is a checkbox "transpose". I clicked that and hit okay, and voilà, the info that was in the x axis is now in the y, as I wanted.

JGraves gravatar imageJGraves ( 2019-02-01 17:14:30 +0100 )edit

Question Tools


Asked: 2013-04-23 18:06:32 +0100

Seen: 12,634 times

Last updated: Mar 14 '14