i have excel 2007 workbook has multiple charts based on 3 critera (account, reason, , factory). each of these reasons split 2 views (one $ , 1 %) have 6 tabs each contain 8 charts (for total of 32 charts). in interest of improving user experience, combine of these charts on 1 tab. basically, want have existing structure while adding 2 controls. first control toggle of charts show either $ or %. second control toggle between account, reason, , factory views. have looked around interwebs , haven't found on this. ideas? have file can share, don't see attachment button.
thanks, rick
Comments
Post a Comment