|
|
 |
| Àâòîðèçàöèÿ |
|
|
|
| Ïîèñê ïî óêàçàòåëÿì |
|
|
|
|
|
|
|
 |
|
|
|
| Jelen B. — Charts and Graphs for Microsoft |
|
|
|
| Ïðåäìåòíûé óêàçàòåëü |
Formatting, plot area, with pictures 64—65
Formatting, plot area, with textures 64—65
Formatting, plot area, with transparency 65
Formatting, rotation (3-D charts) 66—68
Formatting, series 73—74
Formatting, trendlines 69—70
Formatting, walls/floor (3-D charts) 65—66
Formatting, with VBA See Format method
Formulas for stem-and-leaf plots 301—305
Four-icon sets 291
Franklin, Charles 119 435
Freeform shape, creating custom shapes 341—342
Frequency distribution 172—176
Frequency function 157 172—174
Gallery controls 13
Gap between columns, resizing 175
Gap settings, pie of pie charts 139—141
Gap width, changing 398—400
Gap width, of secondary plots, determining 406—407
GapWidth property 398 407
Gemignani, Chris 435
Gemignani, Zach 435
Geographic information See maps
GIF files, converting charts to 355
Glow settings, changing with VBA 384
Gradients, for fill options, applying with VBA 383
Gradients, for plot area 62—63
Graphics See images; shapes; SmartArt; WordArt
Gridlines, formatting 60—61
Gridlines, moving data labels from 49
Gridlines, placement of 61
Gridlines, rogue XY series as 230—236
Gridlines, viewing 59—60
Grouping dialog 273
Grouping, date data in pivot tables 273—274
Grouping, invoice amounts on pivot charts 279—280
Growth, illustrating with Upward Arrow layout (SmartArt) 334—335
Has3DShading property 409
HasRadarAxisLabels property 409
HasSeriesLines property 406
Heat maps See color scales
height (3-D charts) 68
Help features (VBA) 360
Hexadecimal color values, converting to RGB color values 30—31
Hiding axis values 196
Hierarchy category (SmartArt) 320
Hierarchy charts (SmartArt) 337—338
Hierarchy style (SmartArt) 329—330
High-low-close charts, adding volume to 203—208
High-low-close charts, creating 197—199
High-low-close charts, customizing 199—201
High/low lines, inserting 72
Highlighting, columns 108—109
Highlighting, pie chart slices 134
Highlighting, sections of charts 110—111
Hole size (doughnut charts), changing 403
Home ribbon 9
Home ribbon, formatting chart titles 43
Horizontal axis 52
Horizontal axis titles 39
Horizontal axis, axis types, selecting 85
Horizontal axis, built-in options 52—53
Horizontal axis, date-based axes, accuracy of 84
Horizontal axis, date-based axes, converting text to dates 86—92
Horizontal axis, date-based axes, converting to text 100—103
Horizontal axis, date-based axes, dates prior to 1900 93—97
Horizontal axis, date-based axes, displaying as time-based axes 98—100
Horizontal axis, date-based axes, numeric years as dates 92—93
Horizontal axis, date-based axes, text-based axes versus 55—56 84—86
Horizontal axis, defined 39
Horizontal axis, time-based, creating 56
Horizontal gridlines 39
Horizontal Labeled Hierarchy layout (SmartArt) 337—338
Icon sets 281 290—291
Icon sets, aligning with numbers 292
Icon sets, data bars versus 285
Icon sets, reversing order of 293
Icon sets, setup 291
Icons, thumbnail icons for chart types 10—13
Images See also clip art; pictures
Images, exporting charts as 355—356 414
Images, in SmartArt, inserting 328—329
Images, in-cell data bars 4
IncrementRotationHorizontal method 390
IncrementRotationVertical method 390
IncrementRotationX method 390
IncrementRotationY method 390
IncrementRotationZ method 390
INDEX function, combining with MATCH function 249—250
Insert Picture dialog 329
Insert ribbon 8
Insert ribbon, chart types, selecting 9—10
Insert ribbon, charts, creating 15—16
Insert Shapes dialog 341
Inserting chart titles 42
Inserting data labels 48—49
Inserting data tables 50—51
Inserting drop lines 71
Inserting high/low lines 72
Inserting images in SmartArt 328—329
Inserting labels on scatter charts 150—152
Inserting R-squared values in scatter charts 157—159
Inserting second series on scatter charts 153—155
Inserting secondary axis 74
inserting shapes 225—227 339—341
Inserting SmartArt 321—322
Inserting trendline equations 70
Inserting trendlines 113—114
Inserting trendlines on scatter charts 149—150
Inserting up/down bars 72
Instant Cognition blog 435
Interactive training resources 434
Invoice amounts on pivot charts, grouping 279—280
Iterative process, illustrating with Basic Cycle layout (SmartArt) 335
Joining data points on scatter charts 152—153
Juice Analytics blog 435
Kapor, Mitch 88
Keyboard shortcuts, creating charts 17
Keyboard shortcuts, SmartArt text pane 327
Kusleika, Dick 435
Kyd, Charley 236 437
Labeled Hierarchy layout (SmartArt) 337—338
Labeling pie charts 129—130
Labels, defined 39
Labels, formatting 49—50
Labels, inserting 48—49
Labels, inserting, on scatter charts 150—152
Labels, moving, from gridlines 49
Labels, moving, on pie charts 131—132
Labels, rogue XY series as 230—236
Layout ribbon 8 37 369
Layout ribbon, changes with VBA, SetElement method 375—379
Layout ribbon, number of charts available 74
Layouts See also Chart Layouts gallery
Layouts, built-in layouts, applying with VBA 373
Layouts, for SmartArt customizing 338—339
Layouts, for SmartArt customizing, selecting 333
Leader lines in secondary plots 406
Leap year problem 88
Leaves (stem-and-leaf plots), digits as 303—305
Leaves (stem-and-leaf plots), x’s as 301—303
Left function 91
Legend fields, filtering pivot tables 276—278
Legend, defined 39
Legend, formatting 45
Legend, formatting, floating in plot area 46
Legend, formatting, with Format Legend dialog 47
Legend, formatting, with Format Legend dialog, individual entries 47
Legend, resizing 47
LightAngle property 393
| Lighting settings, changing with VBA 395—397
Limited SmartArt styles 332
Line charts, as stock charts 187—188
Line charts, as stock charts, adding volume to 194—197
Line charts, as stock charts, creating 193—194
Line charts, drop lines, inserting 71
Line charts, high/low lines, inserting 72
Line charts, up/down bars, inserting 72
Line charts, when to use 81
Line continuation in VBA 364
Line settings, changing with VBA 383—384
Line types, changing 111—113
LineFormat object 383—384
Lines joining data points, inserting on scatter charts 152—153
Link Data Wizard dialog 309
Linked objects, copying charts to PowerPoint/ Word as 352—353
Linking, cell contents to text in shapes 339—341
Linking, live charts to PowerPoint/Word 349—351
List category (SmartArt) 320
Live charts, copying to PowerPoint/Word as 349—351
Live data, copying charts 348
Live stock charts, creating with web connections 216—218
Live training sessions 435
Location of charts, specifying 366—367
Logarithmic axis 54—55
Logarithmic trendlines 71
Long titles, creating 104—108
Lookup arrays See MATCH function; VLOOKUP function
Lotus 1—2—3 88
Lying with charts, deliberate lies 428—430
Lying with charts, Excel rules 426—427
Lying with charts, obscuring data 427—428
Lying with charts, perspective 423—425
Lying with charts, scale 426
Lying with charts, shrinking charts 425
Macro recorder, Design and Layout ribbons 369
Macro recorder, Format ribbon and 380
Macro recorder, VBA and 360
MAD Magazine 167—170
Major gridlines, formatting 60—61
Major gridlines, placement of 61
Major gridlines, viewing 59—60
MapPoint 307—308. See also maps
MapPoint, cost of 308
MapPoint, maps, creating 308—312
Maps See also MapPoint
Maps, business customers, mapping 315—316
Maps, creating 308—312
Maps, numeric data on 312—314
Maps, pushpins, adding 310—311
Maps, shaded area map style 314—315
Maps, types of, selecting 312
Maps, zooming in/out 311—312
Margin of error, error bars 72—73
MATCH function 247—249
MATCH function, combining with INDEX function 249—250
Material settings, changing with VBA 393—395
Matrix category (SmartArt) 320
Maximum value on vertical axis, changing 56—59
Mehta, Tushar 434
Mid function 91
Mini toolbar, formatting chart titles 43
Minimum value on vertical axis, changing 56—59
Minor gridlines, formatting 60—61
Minor gridlines, placement of 61
Minor gridlines, viewing 59—60
Monochromatic, converting color scales to 288—289
Monthly sales, charting with YTD sales 115—116
Months, displaying as single letters 196
Move Chart dialog 24 225
moving See also copying
Moving average trendlines 71
Moving, chart titles 42
moving, charts 16—18
Moving, charts, between worksheets 224—225
Moving, charts, in VBA 367
Moving, charts, to separate sheets 24—25
Moving, charts, to top of dataset 19
Moving, data labels from gridlines 49
Moving, pie chart labels 131—132
Moving, series, to secondary axis 400—401
Moving, titles 106
Multiple charts, combining into single chart 236—241
Multiple charts, multiple series in pivot charts, creating 272. See also series
Multiple charts, printing with VBA 418—420
Multiple trendlines 118—119
Multiple XY series, creating trellis charts 241—245
Negative numbers (custom number formats) 161
New features, charts 7—8
New features, Excel 2007 VBA 365
New features, pivot tables 267—268
Noncontiguous data, selecting for charts 15
Numbers, aligning with icon sets 292
Numeric data on maps 312—314
Numeric years as dates 92—93
Object settings, finding in Watch window 410—414
object variables 363
Object-oriented code in VBA 361
Objects, referencing with With and End With statements 364
ObjectThemeColor property 382
Obscuring data, lying with 427—428
OFFSET function 246—247
OHLC (open-highlow-close) charts 188—189 197
OHLC (open-highlow-close) charts, creating 202—203
OHLC (open-highlow-close) charts, high-low-close charts, adding volume to 203—208
OHLC (open-highlow-close) charts, high-low-close charts, creating 197—199
OHLC (open-highlow-close) charts, high-low-close charts, customizing 199—201
OneColorGradient method 383
OneNote 356
Open-high-low-close (OHLC) charts See OHLC charts
Order of series, changing 21—23
organization charts 329—330
Organization charts, assistants, adding 330
Organization charts, direct reports, adding 330—331
Organization charts, dotted-line reports, adding 331—332
Overlap property 399
Page Layout ribbon 8
Page Layout ribbon, effects, selecting 29
Page Layout ribbon, number of charts available 74
Page Layout ribbon, themes, changing 27
Paired bar charts 159—162
Paired bar charts, discount/sales correlation example 162—164
Paired bar charts, Kathy Villella example 165—167
Paired bar charts, when to use 157
Paired matching charts, MAD Magazine example 167—170
Pairs of data points, plotting See relationships with charts
Paste Special dialog 352
Pasting See copying
PDF, converting charts to 356
Peltier, Jon 236 434
Performance reviews, creating with radar charts 176—178
Perspective (3-D charts), defined 67—68
Perspective (3-D charts), lying with 423—425
pictures See also clip art; images
Pictures, copying charts to PowerPoint/Word as 351—352
Pictures, for fill options, applying with VBA 383
Pictures, in plot area 64—65
Pictures, in SmartArt 319
Pie charts 80/20 rule 137—138
Pie charts, axes in 51
Pie charts, comparing with doughnut charts 135—136
pie charts, creating 128—129
pie charts, exploding 132—133 401—403
Pie charts, highlighting slices 134
Pie charts, labeling 129—130
Pie charts, moving labels 131—132
Pie charts, rotating 131 401—403
Pie charts, summary slices 138
Pie charts, types of 128
Pie charts, when to use 82 121 127
|
|
|
| Ðåêëàìà |
|
|
|
|
|
Î ïðîåêòå