Civil Engineering Projects
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 ...
Macro 76: Create New Workbook for Each Report Filter Item
Pivot tables provide an excellent mechanism to parse large data sets into separate ...
Macro 75: Print Pivot Table for Each Report Filter Item
Pivot tables provide an excellent mechanism to parse large data sets into printable ...
Macro 74: Automatically Delete Pivot Table Drill- Down Sheets
One of the coolest features of a PivotTable is that it gives you the ability to ...
Macro 73: Apply Pivot Field Restrictions
Like PivotTable restrictions, pivot field restrictions enable us to restrict the types of actions our ...
Macro 72: Apply PivotTable Restrictions
We often send PivotTables to clients, coworkers, managers, and other groups of people. In some cases,
...
Macro 71: Apply Custom Sort to Data Items
On occasion, you may need to apply a custom sort to the data items in your PivotTable. For instance,
...
Macro 70: Sort All Fields in Alphabetical Order
If you frequently add data to your PivotTables, you may notice that new data doesn't ...
Macro 69: Apply Number Formatting for All Data Items
A PivotTable does not inherently store number formatting in its pivot cache. Formatting ...
Macro 68: Set All Data Items to Sum
When creating a PivotTable, Excel, by default, summarizes your data by either counting or summing
the ...
