Chart X-Axis in reverse order!
I have a horizontal bar chart where the vertical (X) axis is in reverse order
of the column where they are listed. There are about 30 values in the X-axis. i.e. the column is listed: Apples Bananas .... Watermelons But in the x-axis it's listed in decending order (Watermelons first, etc.). How can I easily change the x-axis to the same order as the column? Thanks, Joe M. |
Chart X-Axis in reverse order!
That's in forward order. The first item is closest to the low point of the
axis (where the Y axis crosses), the second item is one slot further, etc. Anyway, you can plot forwards or backwards. Right click on the axis, choose Format Axis, and on the Scale tab (or in Excel 2007 on the first tab), check Plot Categories in Reverse Order, and probably also check Value Axis Crosses at Maximum Category. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Joe M." wrote in message ... I have a horizontal bar chart where the vertical (X) axis is in reverse order of the column where they are listed. There are about 30 values in the X-axis. i.e. the column is listed: Apples Bananas ... Watermelons But in the x-axis it's listed in decending order (Watermelons first, etc.). How can I easily change the x-axis to the same order as the column? Thanks, Joe M. |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com