« Inserting data into an Excel worksheet from a C# assembly | Main | EventHandler and EventArgs pattern »

Excel OFFSET function is key to creating charts that track available data

The Excel SERIES function can’t directly use the OFFSET function but it can use names defined using the OFFSET function.

I guess SERIES isn’t technically a function, it certainly is hard to find good documentation on it.

A useful site for figuring things out relating to Excel charting.

 

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)