Excel formulas are powerful, but they have their limits. I used to rely on complex nested formulas that take forever to build and are difficult to troubleshoot, but I have started leaning more heavily ...

This example demonstrates how to add a custom legend item to a legend. To do this, create a new instance of the CustomLegendItem class and add it to the Legend.CustomItems collection.

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.