Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display order of Bar Chart
How do I get a bar chart to display my data in the order I created it rather
then in a sort ascending or descending order. I created my vertical axis categories in the exact order I want the bar chart to display the data however, when the chart is created is rearranged into ascending order of the data not in the order of the categories as I developed it. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display order of Bar Chart
That is not how Excel behaves; when the data is in rows, the first category
of the first row is at the bottom of the bar chart and so on, regardless of the y-values best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bar Chart Vertical Display Order" <Bar Chart Vertical Display wrote in message ... How do I get a bar chart to display my data in the order I created it rather then in a sort ascending or descending order. I created my vertical axis categories in the exact order I want the bar chart to display the data however, when the chart is created is rearranged into ascending order of the data not in the order of the categories as I developed it. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display order of Bar Chart
Your description is rather confusing. Do you mean you created them from the
top down, but they are plotted from the bottom up? Axes start counting where they meet each other. In an XY chart, the point of intersection of the axis is X=0, Y=0. The numbers increase in value as you move away. The bar chart uses a category axis, so it isn't counting numerically, but it is counting the labels. The first label is next to the other axis, so it's at the bottom. The second is one slot further away, and so forth. You can change this by formatting the axis, check Plot Categories in Reverse Order, and to keep the other axis at the bottom, check Value Axis Crosses at Maximum Category. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Bar Chart Vertical Display Order" <Bar Chart Vertical Display wrote in message ... How do I get a bar chart to display my data in the order I created it rather then in a sort ascending or descending order. I created my vertical axis categories in the exact order I want the bar chart to display the data however, when the chart is created is rearranged into ascending order of the data not in the order of the categories as I developed it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Taskbar display order | Excel Discussion (Misc queries) | |||
Change Display Order in Charts | Charts and Charting in Excel | |||
Needing to re-order a datatable display on an Excel chart | Charts and Charting in Excel | |||
Combination chart - area and column - order display? | Charts and Charting in Excel | |||
chart display order | Charts and Charting in Excel |