Dueling Excel 124


Dynamic Stacked Line Chart
See Mr Excel and excelisfun use two methods to lookup a column based on a date and then add all the values for the North Region
1. NA error Trick
2. Dynamic Range Defined Name Formulas that use INDEX function to lookup a cell reference, and inserting Defined Name into chart (select range only and leave sheet reference when inserting a name — later it turns to a workbook reference).
3. Trick the regular line chart by creating a second data set with a formula


Be the first to comment

Leave a Reply