ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Vertical Axis Labels (https://www.excelbanter.com/charts-charting-excel/254751-vertical-axis-labels.html)

William Wolfe[_2_]

Vertical Axis Labels
 
Why do the labels in the vertical axis go in reverse order. The label in
cell A2 is at the bottom of the chart and the label is cell A25 is at the
top.

Thanks,



Andy Pope

Vertical Axis Labels
 
Hi,

Assuming the chart is a Bar chart. Because the first category is plotted
closest to the horizontal axis.

In order to change the order Format the Vertical axis setting both,
Categories in Reverse Order
Value (Y) axis crosses at maximum category

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"William Wolfe" wrote in message
...
Why do the labels in the vertical axis go in reverse order. The label in
cell A2 is at the bottom of the chart and the label is cell A25 is at the
top.

Thanks,




All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com