It's all about the answers!

Ask a question

How to change the location of axis?

Qi Li (1351718) | asked Jul 04 '12, 3:19 p.m.
Usually, in a bar or line chart, the x-axis is on the bottom of the chart, and y-axis is on the left. Is it possible to change x-axis to the top of the chart? Thanks in advance!  

One answer

permanent link
James Moody (3.3k24) | answered Jul 04 '12, 4:40 p.m.
Yes. Go to the chart editor, to the "Format Chart" tab. Select Chart Area > Axis > X-Axis. Under "Origin", instead of "Min" select "Max". This will place the x axis across the top. However, note that this *doesn't* change the ordering of the Y axis... i.e. the smallest value will still be on the bottom of the Y axis and the largest value will be at the top next to the X axis line.

Qi Li commented Jul 04 '12, 5:02 p.m.

Thanks James, it works!

Your answer

Register or to post your answer.