Learn
Macro 86: Mailing a Specific Range as Attachment You may not always want to send your entire workbook through e-mail. This macro demonstrates ...
Macro 85: Mailing the Active Workbook as an Attachment The most fundamental Outlook task you can perform through automation is sending an e-mail. ...
Macro 84: Color Chart Data Points to Match Source Cell Colors In the previous macro, we force each chart series to apply the same colors as their ...
Macro 83: Color Chart Series to Match Source Cell Colors When you create a dashboard, you may have specific color schemes for various types of ...
Macro 82: Label First and Last Chart Points One of the best practices for dashboard building is to avoid overwhelming your customers with too ...
Macro 81: Print All Charts on a Worksheet To print a chart, you can click any embedded chart in your worksheet and then click Print. This prints ...
Macro 80: Create a Set of Disconnected Charts When you need to copy charts from a workbook and paste them elsewhere (another workbook, ...
Macro 79: Align a Chart to a Specific Range Along with adjusting the size of our charts, many of us spend a good bit of time positioning them so ...
Macro 78: Resize All Charts on a Worksheet When building a dashboard, you often want to achieve some level of symmetry and balance. This ...
Macro 77: Transpose Entire Data Range with a PivotTable You may often encounter matrix-style data tables like the one shown in Figure 6-6. The ...
