check the attachement On Sat, Sep 17, 2011 at 5:33 PM, Ayush Jain <jainayus...@gmail.com> wrote:
> Dear group, > > Recently in one of the project, I encountered an issue where we need to > sort the 2-D Bar chart from high to low without sorting the data table > The data table could not be sorted because it is linked with some dynamic > formulas. > > Enclosed is the sample data and chart for you, where I jumbled the > forum top posters data in data table. > So the CHALLENGE for you is that you need to sort bars in chart from high > to low without sorting data. > > Let's see who has the solution. > Keep posting ! > > Best regards, > Ayush Jain > Group Manager > > P.S. Can we use some dynamic formulas in chart series range, I dont know, I > am just thinking. :) > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Excel_quiz.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
