Stephan Member Mar 13, 2017 #1 Scroll Bar & Dynamic Charts: Very easy to do, see attached filem done in XL2003 with no VB & no defined names. Just Offset formula & Forms Scroll Bar linkcell. see VERTICAL SCROLL bar Column A: A2:A11. Attachments Scroll VERT##Multi Pareto.xls 48.5 KB · Views: 12
Scroll Bar & Dynamic Charts: Very easy to do, see attached filem done in XL2003 with no VB & no defined names. Just Offset formula & Forms Scroll Bar linkcell. see VERTICAL SCROLL bar Column A: A2:A11.
Stephan Member Mar 14, 2017 #2 Some more useful files, Dynamic Charts, 1 series HORIZ or VERT, 1 or 2 Header. Attachments Dyn Chart 1S#HORIZ.xls 32 KB · Views: 12 Dyn Chart 1S#VERT.xls 91 KB · Views: 8 Dyn Chart DBL HDR#HORIZ.xls 32.5 KB · Views: 6 Dyn Chart DBL HDR#VERT.xls 37.5 KB · Views: 7