Create method, arguments, 230
PivotField.Caption property, changing
captions with, 244
PivotField.NumberFormat property, 242
PivotTable Field List pane
adding fields to, 231
in Excel 2007, 228
PivotTable report
changing field names in, 243??“244
changing look of, 245??“247
changing number format in, 242
contents of, 225
creating using drag-and-drop, 225??“227
default view, 225
effect of blank records on, 238??“242
example of completed, 227
formatting to, 238??“242, 245??“247
getting current source data for, 236
putting data into, 223??“247
refreshing data in, 235??“238
sales summary by city within state,
227??“228
showing Sum of Qty and Sum of Amount
fields, 244
updating, 236
PivotTable Tools ribbon, Options ribbon
shown on, 238
PivotTable01.xlsx, downloading and opening,
223
/PivotTable02_Formatting.xlsm,
downloading, 238
PivotTables, 223??“247
creating and recording macro for, 224??“225
new rows added to source data, 237
new sheet and starting range for, 231
Position property for, 232
when to use, 223
PlaceChart subroutine, creating, 213??“215
PlaceChartDynamic subroutine
adding variable declarations to, 217??“218
completing, 217??“221
creating, 216
nINDEX 357
data range and legend information,
218??“220
getting coordinates from existing chart,
218
ready for modifications, 217
testing, 220??“221
PlaceData method, adding code for, 346
PlaceData subroutine, adding to ThisAddin
application, 347
Position property, for PivotTables, 232
PowerPoint 12.
Pages:
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324