Weird Excel bar diagram behaviour

Posted by Simon on Super User See other posts from Super User or by Simon
Published on 2010-03-14T16:07:26Z Indexed on 2010/03/14 20:05 UTC
Read the original article Hit count: 358

Filed under:

excel-2003

|

diagram

Hi

I have a very simple question. I wanna have a diagram with the following table

Apple   30  40  50
Pears   200 300 400
Bananas 10  20  30

The weird thing, when I try to draw a bar diagram the order of the bars change. So Excel draws me first the Bananas, the the pears and finally the apple bar... Is there anyway to tell Excel 2003 that it keeps the order?

Thank you very much

© Super User or respective owner

Weird Excel bar diagram behaviour

Posted by Simon on Super User See other posts from Super User or by Simon
Published on 2010-03-14T16:13:25Z Indexed on 2010/03/14 20:15 UTC
Read the original article Hit count: 356

Filed under:

excel

I have a very simple question. I want to have a diagram with the following table:

Apple   30  40  50
Pears   200 300 400
Bananas 10  20  30

The weird thing is, when I try to draw a bar diagram the order of the bars changes. So Excel first draws the bananas, then the pears, and finally the apple bar... Is there anyway to tell Excel 2003 to keep the original order?

Thank you very much

© Super User or respective owner

Related posts about excel-2003

Migrating from VBA Excel 2003

as seen on Super User - Search for 'Super User'
I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so... Whats the best way to implement a gui over a excel vba program (office 2003)? (are there any tools for that... I want to move away from the office suite, but still have it in… >>> More
Migrating from VBA Excel 2003

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so... Whats the best way to implement a gui over a excel vba program (office 2003)? (are there any tools for that... I want to move away from the office suite, but still have it in… >>> More
Excel: how to add cells to named range

as seen on Super User - Search for 'Super User'
I have a named range for 3 cells in excel 2003 I need to insert 1 more cell into this named range how do I achieve this in excel 2003 >>> More
How to stop Excel 2003 from loading a Gazillion files

as seen on Super User - Search for 'Super User'
One of my soon-to-be-ex-friends got an Excel file from another friend of his and decided to click on it. It started opening all kinds of files from within Excel. Over 200 and still counting when he called me. I told him to go to task manager, which showed a LOT of files in the applications tab, but… >>> More
Create or Open an .xlsx file having >256 columns in MS Excel 2003

as seen on Super User - Search for 'Super User'
I'm using Microsoft Office 2003. I have installed 'Microsoft Office Compatibility Pack for Word, Excel, Powerpoint 2007' to support new xml based formats (.docx, .xlsx, .pptx). Now given that I have installed Compatibility pack, can I create or open a Microsoft Excel 2007 file (.xlsx) having more… >>> More

Related posts about diagram

UML class diagram vs ER database diagram

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm a little confused, I'm developing a program, the program consist in two parts, the server and the clients, there are groups, places, messages... stored in the server, and the clients has to connect with it. I've design the use cases diagram, the activity diagrams, and I have design the class… >>> More
Sequence diagram to state diagram

as seen on Stack Overflow - Search for 'Stack Overflow'
Can we make state diagram from sequence diagram....Is there any tool for the same... plz reply ASP thnx in advance........... >>> More
Mapping between 4+1 architectural view model & UML

as seen on Programmers - Search for 'Programmers'
I'm a bit confused about how the 4+1 architectural view model maps to UML. Wikipedia gives the following mapping: Logical view: Class diagram, Communication diagram, Sequence diagram. Development view: Component diagram, Package diagram Process view: Activity diagram Physical view: Deployment… >>> More
Sequence diagram with javascript to ajax to php calls

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm needing to document some functionality on a page that has a jQuery watching for a button click. On the button click the script pulls info from two fields and makes a ajax call to a php script passing these values to the php script. >>> More
Nice network diagram editor?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Writing a commercial proposal, I want to create a nice graphic showing the clients the architecture I thought of for their IT network, with servers, network connections, firewall, load-balancing, etc. For years I have been using dia, but I am tired of it, the results are not satisfying, very few… >>> More