Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, ...

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.