|
|
 |
| Àâòîðèçàöèÿ |
|
|
|
| Ïîèñê ïî óêàçàòåëÿì |
|
|
|
|
|
|
|
 |
|
|
|
| Jelen B. — Charts and Graphs for Microsoft |
|
|
|
| Ïðåäìåòíûé óêàçàòåëü |
Pie of pie charts 138—139
Pie of pie charts, changing settings in VBA 403—408
Pie of pie charts, creating 142—143
Pie of pie charts, gap settings 139—141
Pie of pie charts, splitting series 141—142
Pie of pie charts, when to use 127
pivot charts See also pivot tables
Pivot charts, adding to pivot tables 268
Pivot charts, chart type, changing 271—272
Pivot charts, creating 269—271
Pivot charts, creating, for all Report Filter values 278—279
Pivot charts, creating, with VBA 416—420
Pivot charts, defined 267
Pivot charts, simulating scatter charts with 279—280
Pivot charts, with multiple series, creating 272
pivot tables See also pivot charts
Pivot tables, adding pivot charts to 268
Pivot tables, blank cells, filling with zeros 268
Pivot tables, date data, grouping 273—274
Pivot tables, defined 267
pivot tables, filtering 274
Pivot tables, filtering, for Axis and Legend fields 276—278
Pivot tables, filtering, with Report Filter field 275—276
Pivot tables, new features 267—268
Pivot tables, preparing data for 268—269
Plot area, defined 38
Plot area, floating legend in 46
Plot area, formatting 61—62
Plot area, formatting, with gradients 62—63
Plot area, formatting, with pictures 64—65
Plot area, formatting, with textures 64—65
Plot area, formatting, with transparency 65
Politikal Arithmetik blog 435
Polynomial trendlines 71
Portable Document Format (PDF), converting charts to 356
Power trendlines 71
PowerFrameworks.com 432—433
PowerPoint, copying charts to 347—349
PowerPoint, copying charts to, as linked object 352—353
PowerPoint, copying charts to, as live chart linked to copy of workbook 350—351
PowerPoint, copying charts to, as live chart linked to original workbook 349—350
PowerPoint, copying charts to, as picture 351—352
PowerPoint, creating charts with copied Excel data 353—354
Preset shape effects 76—77
PresetGradient method 383
PresetLighting property 393
PresetMaterial property 393
PresetTextured method 382
Printing multiple charts with VBA 418—420
Privacy, copying charts 348
Pro/con decisions, Balance layout (SmartArt) for 334
Process category (SmartArt) 320
Professional chart designers 436
Project Explorer 359
Properties window 359
Pushpins on maps, adding 310—311
Pyramid category (SmartArt) 320
R-squared values (trendlines) 70
R-squared values (trendlines), inserting in scatter charts 157—159
Radar charts 176—178
Radar charts, axes in 51
Radar charts, changing settings in VBA 409—410
Radar charts, Manoj Sharma example 178—180
Radar charts, when to use 147 157
Ranges of data, dynamic ranges in charts 253—256
Ranges of data, specifying, in dynamic charts 246—247
Ranges of data, specifying, in VBA 361—362
Ranges of dates, converting from text to dates 91—92
Referencing, charts in VBA 365—369
Referencing, objects with With and End With statements 364
Reflection settings, changing with VBA 385
Relationship category (SmartArt) 320
Relationships with charts, bubble charts 170—172
Relationships with charts, chart types, list of 147—148 156—157
Relationships with charts, frequency distribution 172—176
Relationships with charts, Gene Zelazny example 180—183
Relationships with charts, paired bar charts 159—162
Relationships with charts, paired bar charts, discount/sales correlation example 162—164
Relationships with charts, paired bar charts, Kathy Villella example 165—167
Relationships with charts, paired matching charts, MAD Magazine example 167—170
Relationships with charts, radar charts 176—178
Relationships with charts, radar charts, Manoj Sharma example 178—180
Relationships with charts, scatter charts 148
Relationships with charts, scatter charts, drawing with 155—156
Relationships with charts, scatter charts, labels, inserting 150—152
Relationships with charts, scatter charts, lines joining data points, inserting 152—153
Relationships with charts, scatter charts, R-squared values, inserting 157—159
Relationships with charts, scatter charts, second series, inserting 153—155
Relationships with charts, scatter charts, trendlines, inserting 149—150
Relationships with charts, surface charts 183—184
Relationships with charts, surface charts, 3-D rotation 185
Relationships with charts, surface charts, depth axis 185
Repeating text, creating charts via 296—297
Replacing data markers with clip art 77—78
Replacing data markers with shapes 78—79
Report Filter values, creating pivot charts for 278—279
Report Filter values, filtering pivot tables 275—276
REPT function, creating charts via 296—297
ResetRotation method 390
resizing See also size
Resizing, chart titles 43
Resizing, charts 16
Resizing, charts, for dashboards 219—221
Resizing, gap between columns 175
Resizing, legend 47
Resizing, secondary plots 407
Resizing, smallest/largest data bars 284—285
Resizing, titles 106
Resources, blogs 435
Resources, charting tutorials 434
Resources, interactive training 434
Resources, live training sessions 435
Resources, PowerFrameworks.com 432—433
Resources, professional chart designers 436
Resources, Tufte, Edward 433—434
Resources, utilities 436—437
Resources, visual design stores 435
Resources, Zelazny, Gene 431—432
Reversing icon set order 293
RGB color values 30
RGB color values, converting from hexadecimal 30—31
RIGHT function 91
Rogue XY series, as vertical axis gridlines/labels 230—236
Rogue XY series, combining multiple charts into single chart 236—241
Rotating, pie charts 131 401—403
Rotating, surface charts 185
Rotation settings (3-D charts), changing with VBA 386—390
Rotation settings (3-D charts), finding in Watch window 413—414
Rotation settings (3-D charts), formatting 66—68
RotationX property 390
RotationY property 390
RotationZ property 390
Rows, counting 362
Rows, final row, jumping to 362
Rows, switching with columns 20—21
Sales/discount correlation example (paired bar charts) 162—164
Saving, charts as templates 79
Saving, custom themes 34
Say It with Charts Complete Toolkit (Zelazny) 104 431
Scale, lying with 426
Scale, of vertical axis 53
Scale, of vertical axis, changing 56—59
scatter charts 148
Scatter charts, axes in 51
Scatter charts, drawing with 155—156
Scatter charts, labels, inserting 150—152
Scatter charts, lines joining data points, inserting 152—153
Scatter charts, multiple XY series, creating trellis charts 241—245
Scatter charts, R-squared values, inserting 157—159
Scatter charts, rogue XY series, as vertical axis gridlines/labels 230—236
| Scatter charts, rogue XY series, combining multiple charts into single chart 236—241
Scatter charts, second series, inserting 153—155
Scatter charts, simulating with pivot charts 279—280
Scatter charts, trendlines 119—120
Scatter charts, trendlines, inserting 149—150
Scatter charts, when to use 147 156
Screen captures, exporting charts as 356
Scrollbar controls, creating charts via 297—300
Scrolling charts, creating 256—259
Second series See series secondary axis
Second series, inserting 74
Second series, moving series to 400—401
Secondary plots, categories in, determining 405—406
Secondary plots, gap width, determining 406—407
Secondary plots, leader lines in 406
Secondary plots, resizing 407
Secondary plots, slices in, determining 404—405
Secondary vertical axis 52
SecondaryPlot property 405
SecondPlotSize property 407
Sections of charts, highlighting 110—111
Select Data icon (Design ribbon) 21—23
Select Data Source dialog 21—23
Selecting, axis types 85
Selecting, chart layouts 25—26
Selecting, chart types 2—3 9—10 81—83
Selecting, color schemes 26—27
Selecting, colors for custom themes 32—33
Selecting, contiguous data for charts 14
Selecting, effects for custom themes 29—30
Selecting, fonts for custom themes 33—34
Selecting, forecast methods for trendlines 70—71
Selecting, layouts for SmartArt 333
Selecting, map types 312
Selecting, noncontiguous data for charts 15
Sequence of columns for stock charts 191
SERIES function 232
Series, adding to highlight sections of charts 110—111
Series, chart types and 398
Series, combining chart types 223—224
Series, Format Series dialog 397—398
Series, Format Series dialog, bar of pie and pie of pie chart settings 403—408
Series, Format Series dialog, bubble size settings 408—409
Series, Format Series dialog, gap width settings 398—400
Series, Format Series dialog, radar and surface chart settings 409—410
Series, Format Series dialog, rotating and exploding charts 401—403
Series, Format Series dialog, secondary axis settings 400—401
Series, formatting 73—74
Series, inserting on scatter charts 153—155
Series, multiple series, creating in pivot charts 272
Series, multiple XY series, creating trellis charts 241—245
Series, order of, changing 21—23
Series, rogue XY series, as vertical axis gridlines/labels 230—236
Series, rogue XY series, combining multiple charts into single chart 236—241
Series, rogue XY series, switching with categories 20—21
SetElement method 365 375—379
SetPresetCamera method 386—389
Shaded area map style 314—315
Shadow settings, changing with VBA 384
Shape Styles gallery 74—75
Shapes 318. See also SmartArt
Shapes, as data markers 78—79
Shapes, changing 341
Shapes, converting SmartArt to 343—345
Shapes, custom shapes, creating 341—342
Shapes, effects 75—77
Shapes, in SmartArt, changing 325—326
Shapes, in SmartArt, changing, in text pane 326—328
Shapes, inserting 225—227 339—341
Shapes, Shape Styles gallery 74—75
Shapes, text, linking to cell contents 339—341
Sharing custom themes 35. See also copying
Sharma, Manoj 178—180
Sheets, moving charts to 24—25. See also chart sheets
shortcuts See keyboard shortcuts
Show Report Filter Pages dialog 278
Shrinking charts, lying with 425
Side wall (3-D charts) 40
Singh, Mala 263 436
SIZE See also resizing
Size, of bubbles, changing settings in VBA 408—409
Size, of charts, specifying 366—367
Size, of text in SmartArt, changing 325
Slices, in secondary plots, determining 404—405
Slices, of pie charts, exploding 132—133
Slices, of pie charts, highlighting 134
Slices, of pie charts, summary slices 138
SmartArt 317—319. See also shapes
SmartArt, bullet points in 319
SmartArt, categories of 320
SmartArt, colors, changing 322
SmartArt, common elements in 319
SmartArt, converting to shapes 343—345
SmartArt, Design ribbon 324
SmartArt, for business, Balance layout 334
SmartArt, for business, Basic Cycle layout 335
SmartArt, for business, customizing layouts 338—339
SmartArt, for business, Diverging Radial layout 335—336
SmartArt, for business, hierarchy charts 337—338
SmartArt, for business, presentations 334
SmartArt, for business, Table List layout 336
SmartArt, for business, Upward Arrow layout 334—335
SmartArt, for business, Venn diagrams 336—337
SmartArt, Format ribbon 324
SmartArt, Hierarchy style 329—330
SmartArt, images, inserting 328—329
SmartArt, in text pane 326—328
SmartArt, inserting 321—322
SmartArt, layouts, selecting 333
SmartArt, limited styles in 332
SmartArt, organization charts 329—330
SmartArt, organization charts, assistants, adding 330
SmartArt, organization charts, direct reports, adding 330—331
SmartArt, organization charts, dotted-line reports, adding 331—332
SmartArt, pictures in 319
SmartArt, shapes, changing 325—326
SmartArt, styles 319
SmartArt, styles, applying 323
SmartArt, styles, changing 323—324
SmartArt, text size, changing 325
Snag-It 356
Soft edge settings, changing with VBA 385—386
Sorting bar chart items 122—123
sources See data sources
SparkMaker 437
Specialty charts, examples of 263—265
Speedometer Chart Creator 436
spinning See rotating
Splits (stocks) in stock charts 191—193
Splitting series in pie of pie charts 141—142
SplitType property 404
SplitValue property 404
Stacked bar charts, component emphasis with 125
Stacked bar charts, when to use 83
stacked column charts 11
Stacked column charts, as comparison charts 117—118
Stacked column charts, limitations of 116—117
Stacking multiple charts into single chart 236—241
Stem-and-leaf plots 301
Stem-and-leaf plots, creating, with digits as leaves 303—305
Stem-and-leaf plots, creating, with x’s as leaves 301—303
Stock charts, Adjusted Close column for stock splits 191—193
Stock charts, candlestick charts 189
Stock charts, candlestick charts, colors in 210
Stock charts, candlestick charts, competition and volume in 213—216
Stock charts, candlestick charts, creating 209
Stock charts, candlestick charts, volume in 210—213
Stock charts, column sequences 191
Stock charts, data sources for 189—190
Stock charts, line charts 187—188
|
|
|
| Ðåêëàìà |
|
|
|
|
|
Î ïðîåêòå