A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Display order of Bar Chart



 
 
Thread Tools Display Modes
  #1  
Old March 23rd 09, 07:06 PM posted to microsoft.public.excel.charting
Bar Chart Vertical Display Order
external usenet poster
 
Posts: 1
Default 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.
Ads
  #2  
Old March 24th 09, 01:57 AM posted to microsoft.public.excel.charting
Bernard Liengme[_3_]
external usenet poster
 
Posts: 1,104
Default 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  
Old March 24th 09, 02:47 AM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 6,582
Default 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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Taskbar display order Thomas Dziuk Excel Discussion (Misc queries) 5 February 4th 08 06:13 PM
Change Display Order in Charts lesy99 Charts and Charting in Excel 1 August 4th 06 07:05 PM
Needing to re-order a datatable display on an Excel chart Poody Charts and Charting in Excel 0 April 11th 06 01:40 PM
Combination chart - area and column - order display? Gary King Charts and Charting in Excel 1 January 4th 06 08:40 PM
chart display order Guy H via OfficeKB.com Charts and Charting in Excel 6 July 15th 05 12:32 AM


All times are GMT +1. The time now is 04:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.