spot_img

Chart From Right To Left In Excel

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

Chart from Right to Left

1. Enter data into Excel sheet and select the data.

data table

2. Go to insert and select any of the desired chart.

ribbon insert chart

3. Right click vertical axis, then click format axis and go labels.

left axis

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

ready chart right to left example

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

I hope you enjoyed the trick.

Regards for Carlo and football fans from Italy.

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell