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
Excel_quiz.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
