Fun Excel Bar Chart Right To Left

Im not sure of the value of creating a bar that goes right to left but heres how you would do it.

Excel bar chart right to left. Take another look at the column chart and note where the origin of the axis system is located. Then a clustered bar chart is inserted into the worksheet. Select the radio button next to Descendin.

You can do this manually using your mouse or you can select a cell in your range and press CtrlA to select the data automatically. Nothing seems to. Select the data set Click the Insert tab.

Select the whole data range you will create a bi-directional bar chart based on and then click Insert Insert Column or Bar Chart Clustered Bar. Click the Clustered Column option. 1 click File tab and select Options from the left menu list.

Once your data is selected click Insert Insert Column or Bar Chart. 3 click Ok button. Top Bottom Left Right or.

Make sure the Start Date is selected on the left pane and click the Edit button on the right pane under Horizontal Category Axis Labels. Select Values in reverse order and your chart should then go from right to left. In this case the first column is Cuba and the last is Barbados so the columns match the order of the source data moving moving top to bottom.

Then on the Format Axis window check the box for Categories in Reverse Order. This will result in the secondary y horizontal axis showing up at the top of the chart. One would think that by highlighting the label area text box and clicking on the alignment options one could left-justify the text.