Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reverse chart column and row order | Charts and Charting in Excel | |||
Reverse chart order | Charts and Charting in Excel | |||
Reverse chart order | Charts and Charting in Excel | |||
How to reverse the order of bars in Bar Clustered chart? | Excel Discussion (Misc queries) | |||
scatterplot chart with reverse axis | Charts and Charting in Excel |