In excel, I have a set of percentages and a set of text labels. When I create a bar graph going horizontally, I see "label 5" at the top and "label 1" at the bottom. There doesn't seem to be a way to flip the chart. What am I missing here?
| label 1 | 10% |
| label 2 | 30% |
| label 3 | 20% |
| label 4 | 55% |
| label 5 | 12% |
1 Answer
Select the Format tab. Excel chart tools - Select the Format tab Go to the Chart Elements drop down list and pick Vertical (Value) Axis. Excel charts - Vertical(value) Axis Click the Format Selection button to see the Format Axis window On the Format Axis window tick the Values in reverse order checkbox. Tick the Values in reverse order checkbox on this window
