How to flip a chart in Excel

Why to create standard charts in Excel? Try something extraordinary. Let’s learn to create a chart from right to left. It means that that axis will flip on the right side of your chart. Just follow these steps.

Chart from Right to Left

Enter data into Excel sheet and select the data.

chart right to left data table

Go to insert and select any of the desired chart.

ribbon insert right to left chart

Right-click the vertical axis, then click format axis and go labels.

left axis

Now open the drop-down menu under labels and select high to move the vertical axis towards the left. Ready chart from right to left looks like that:

ready chart right to left example

Here you can download a free Chart from right to left template.

Values in Reverse Order

You can also set values in reverse order. Just right click your axis and choose Format Axis.

Right click Format Axis

From the menu choose Values in Reverse order.

Values in reverse order

Now your bar chart is inserted from right to left.

Values Right to Left example bar chart

This is how to flip a chart in Excel.

How to move X axis

If you are not satisfied with rotating your chart, then move the axis as well.

In Excel, you can move the axis so that it intersects the graph at the point that suits you.

Now I will teach you how to move the x axis higher. I don’t want the x axis to be at the bottom of the plot. I will move the x axis higher in the chart.

I don’t want the x axis to cross the y axis at point 0. I want the x axis to intersect the y axis at 0.2.

See also  How to use Sparklines in Excel

It’s easy to move the x-axis up the chart. To change the position of the x-axis, left-click on it. In the Formax Axis menu, go to Axis Options. In the Vertical axis crosses field, click on Axis value and enter the value. I entered 0.2.

format axis vertical axis crosses

The x axis has moved and now intersects the y axis at 0.2.

x axis move higher

I hope you enjoyed the trick.