Hello,

I want to export data from Excel, perform some calculations on it, and then link the data to an Excel chart. Although the exported data has a named range with it, the area where I've done calculations doesn't have a dynamic named range. It's the calculated area that I want my chart to reference. Does one have an example of code to share that makes my chart reference only the dimensions of the calculated area that correspond to the variable dimensions of the exported data? I'm sure it's some combination of the offset function. I just don't know exactly how to make it work.