• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Arranging items in ascending order on a chart in excel 2003

waseem

New Member
Hi everyone.


can I arrange all items on x-axis in a chart in ascending order based on values on y-axis? Actually i have a data matrix having various columns of data categories for respective variable in rows. Therefore i cannot sort a particular column in my data series. Instead I want excel charts to automatically arrange in ascending/descending order(highest bars first)


Although I dont know ABC of VB but is it possible to do so through Vba in excel 2003?
 

Hui

Excel Ninja
Staff member
Waseem

What you have described is a Pareto chart

Have a read of:

http://chandoo.org/wp/2009/09/02/pareto-charts/
 

waseem

New Member
Thanks a lot Hui.

I guess i didnt described the requirement adequately. I can send you my excel sheet for better understanding. Can you please share your email with me?


Appreciate your usual support
 

Hui

Excel Ninja
Staff member
Waseem


Although you say you cannot sort due to your "data matrix", the only way to do what you want is to insert an intermediate block of cells which will do the sorting automatically


Please post your file somewhere:

http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Top