The OFFSET function lets you define a dynamic ... In the example below, we will focus on Excel tables, explore slicers, chart customization, and more. Must-have Excel add-ins you cant afford ...

Select the Sparkline chart cell, click the Design item in ... array for a value that matches the year to cell J1, so Excel can use the OFFSET function to pull the data from that year and display ...