|
|
Àâòîðèçàöèÿ |
|
|
Ïîèñê ïî óêàçàòåëÿì |
|
|
|
|
|
|
|
|
|
|
Jelen B. — Charts and Graphs for Microsoft |
|
|
Ïðåäìåòíûé óêàçàòåëü |
Stock charts, line charts, adding volume to 194—197
Stock charts, line charts, creating 193—194
Stock charts, live charts, creating with web connections 216—218
Stock charts, OHLC charts 188—189 197
Stock charts, OHLC charts, creating 202—203
Stock charts, OHLC charts, high-low-close charts, adding volume to 203—208
Stock charts, OHLC charts, high-low-close charts, creating 197—199
Stock charts, OHLC charts, high-low-close charts, customizing 199—201
Stock charts, types of 187
Stock charts, when to use 82
stop command 411
Storage format, of dates 87—88
Storage format, of times 88
Stratifying See grouping
Styles See also Chart Styles
Styles gallery 373—375
Styles, gallery, built-in styles, applying with VBA 373—375
Styles, gallery, in SmartArt 319
Styles, gallery, in SmartArt, applying 323
Styles, gallery, in SmartArt, changing 323—324
Styles, gallery, in SmartArt, limited styles 332
Subordinates in organization charts, adding 330—331
Subsets of cells, data bars for 286—287
SUMIFS function 14
Summarizing See grouping
Summary data, creating for charts 14
Summary slices in pie charts 138
Super-variables 363
Support, blogs 435
Support, charting tutorials 434
Support, interactive training 434
Support, live training sessions 435
Support, PowerFrameworks.com 432—433
Support, professional chart designers 436
Support, Tufte, Edward 433—434
Support, utilities 436—437
Support, visual design stores 435
Support, Zelazny, Gene 431—432
Surface charts 183—184
Surface charts, 3-D rotation 185
Surface charts, axes in 51
Surface charts, changing settings in VBA 409—410
Surface charts, depth axis 185
Surface charts, limitations of 147
SWIPE (visual design store) 435
Switching series and categories 20—21
Swoosh Arrow shape (SmartArt) 334—335
Table List layout (SmartArt) 336
Table values, finding 247—250
Takasaki, Earl 263
Taylor, Ivana 120
Technical support, blogs 435
Technical support, charting tutorials 434
Technical support, interactive training 434
Technical support, live training sessions 435
Technical support, PowerFrameworks.com 432—433
Technical support, professional chart designers 436
Technical support, Tufte, Edward 433—434
Technical support, utilities 436—437
Technical support, visual design stores 435
Technical support, Zelazny, Gene 431—432
templates, creating 79
Templates, specifying in VBA 372
text See also WordArt
Text boxes, as titles 106—108
Text filters for pivot tables 276—277
Text pane (SmartArt) 326—328
Text size in SmartArt, changing 325
Text, converting, dates to 100—103
Text, converting, to dates 86—92
Text, converting, to WordArt 74
Text, in shapes, linking to cell contents 339—341
Text, repeating text, creating charts via 296—297
Text-based axes 52
Text-based axes, date-based axes versus 55—56 84—86
Textures, for fill options, applying with VBA 382
Textures, in plot area 64—65
The Visual Display of Quantitative Information (Tufte) 433
themes, changing 27—28
Themes, creating 28
Themes, creating, colors, selecting 32—33
Themes, creating, complementary colors, finding 31—32
Themes, creating, effects, selecting 29—30
Themes, creating, fonts, selecting 33—34
Themes, creating, saving custom themes 34
Themes, creating, sharing custom themes 35
Themes, creating, using custom themes 35
Thermometer charts, creating 259—260
Three-color scales, converting to/from two-color scales 290
Three-icon sets 290
Thumbnail icons for chart types 10—13
Time comparisons in bar charts 123—124
Time progression See trends in charts
Time-based axes 52. See also date-based axes
Time-based axes, creating 56
Time-based axes, displaying date-based axes as 98—100
Times, storage format of 88
Titles, axis titles, changing with VBA 380
Titles, axis titles, formatting 44
Titles, chart titles, changing with VBA 380
Titles, chart titles, defined 38
Titles, chart titles, formatting 43—44
Titles, chart titles, inserting 42
Titles, chart titles, moving 42
Titles, chart titles, resizing 43
Titles, deleting 106—108
Titles, long titles, creating 104—108
Titles, moving 106
Titles, resizing 106
Titles, text boxes as 106—108
Tolerance, error bars 72—73
ToolTips, creating charts 15
Top of dataset, moving charts to 19
Top-left cell, leaving blank 23—24
Total Training 434
Training resources, blogs 435
Training resources, charting tutorials 434
Training resources, interactive training 434
Training resources, live training sessions 435
Training resources, PowerFrameworks.com 432—433
Training resources, professional chart designers 436
Training resources, Tufte, Edward 433—434
Training resources, utilities 436—437
Training resources, visual design stores 435
Training resources, Zelazny, Gene 431—432
Transparency of plot area 62 65
Trellis charts, creating 241—245
Trend charts (stock charts), Adjusted Close column for stock splits 191—193
Trend charts (stock charts), candlestick charts 189
Trend charts (stock charts), candlestick charts, colors in 210
Trend charts (stock charts), candlestick charts, competition and volume in 213—216
Trend charts (stock charts), candlestick charts, creating 209
Trend charts (stock charts), candlestick charts, volume in 210—213
Trend charts (stock charts), column sequences 191
Trend charts (stock charts), data sources for 189—190
Trend charts (stock charts), line charts 187—188
Trend charts (stock charts), line charts, adding volume to 194—197
Trend charts (stock charts), line charts, creating 193—194
Trend charts (stock charts), live charts, creating with web connections 216—218
Trend charts (stock charts), OHLC charts 188—189 197
Trend charts (stock charts), OHLC charts, creating 202—203
Trend charts (stock charts), OHLC charts, creating, high-low-close charts, adding volume to 203—208
Trend charts (stock charts), OHLC charts, high-low-close charts, creating 197—199
Trend charts (stock charts), OHLC charts, high-low-close charts, customizing 199—201
Trend charts (stock charts), types of 187
Trend charts (stock charts), when to use 82
Trendlines 68—69
Trendlines, defined 41
Trendlines, equations for, adding to charts 70
Trendlines, forecast methods, selecting 70—71
| Trendlines, formatting 69—70
Trendlines, in scatter plots 119—120
Trendlines, inserting 113—114
Trendlines, inserting, on scatter charts 149—150
Trendlines, lying with 427—428
Trendlines, multiple trendlines 118—119
Trendlines, R-squared values, inserting in scatter charts 157—159
Trends in charts, axis types, selecting 85
Trends in charts, chart types, selecting 81—83
Trends in charts, date-based axes, accuracy of 84
Trends in charts, date-based axes, converting text to dates 86—92
Trends in charts, date-based axes, converting to text 100—103
Trends in charts, date-based axes, dates prior to 1900 93—97
Trends in charts, date-based axes, displaying as time-based axes 98—100
Trends in charts, date-based axes, numeric years as dates 92—93
Trends in charts, date-based axes, text-based axes versus 84—86
Trends in charts, limitations of 116—117
Trends in charts, monthly and YTD sales 115—116
Trends in charts, stacked column charts as comparison charts 117—118
Trends in charts, trendlines, in scatter plots 119—120
Trends in charts, trendlines, inserting 113—114
Trends in charts, trendlines, multiple trendlines 118—119
Troubleshooting color scales 290
Tufte, Edward 78 433—435
Two-color scales, converting to/from three-color scales 290
TwoColorGradient method 383
Underscore (_), VBA line continuation 364
Up/down bars, defined 41
Up/down bars, inserting 72
Upward Arrow layout (SmartArt) 334—335
UserForms, creating dynamic charts with VBA 414—416
UserPicture method 383
Utilities, list of 436—437
Validation drop-downs, creating dynamic charts with 250—253
Value filters for pivot tables 277
variables, declaring 363
variables, object variables 363
Variables, variables, comparing See relationships with charts
VaryByCategories property 399
VBA (Visual Basic for Applications) 357
VBA (Visual Basic for Applications), axis titles, changing 380
VBA (Visual Basic for Applications), backward compatibility 357
VBA (Visual Basic for Applications), built-in layouts, applying 373
VBA (Visual Basic for Applications), built-in styles, applying 373—375
VBA (Visual Basic for Applications), chart titles, changing 380
VBA (Visual Basic for Applications), chart types, specifying 369—370 372
VBA (Visual Basic for Applications), charts, creating 366—367
VBA (Visual Basic for Applications), charts, moving 367
VBA (Visual Basic for Applications), charts, referencing 365—369
VBA (Visual Basic for Applications), comments 364—365
VBA (Visual Basic for Applications), Developer ribbon, enabling 358
VBA (Visual Basic for Applications), dynamic charts, creating 414—416
VBA (Visual Basic for Applications), enabling 358
VBA (Visual Basic for Applications), exporting charts as graphics 414
VBA (Visual Basic for Applications), Format method 380—381
VBA (Visual Basic for Applications), Format method, 3-D rotation settings 386—390
VBA (Visual Basic for Applications), Format method, bevel settings 390—393
VBA (Visual Basic for Applications), Format method, fill options 381—383
VBA (Visual Basic for Applications), Format method, glow settings 384
VBA (Visual Basic for Applications), Format method, lighting settings 395—397
VBA (Visual Basic for Applications), Format method, line settings 383—384
VBA (Visual Basic for Applications), Format method, material settings 393—395
VBA (Visual Basic for Applications), Format method, reflection settings 385
VBA (Visual Basic for Applications), Format method, shadow settings 384
VBA (Visual Basic for Applications), Format method, soft edge settings 385—386
VBA (Visual Basic for Applications), Format Series dialog, bar of pie and pie of pie chart settings 403—408
VBA (Visual Basic for Applications), Format Series dialog, bubble size settings 408—409
VBA (Visual Basic for Applications), Format Series dialog, changes in 397—398
VBA (Visual Basic for Applications), Format Series dialog, gap width settings 398—400
VBA (Visual Basic for Applications), Format Series dialog, radar and surface chart settings 409—410
VBA (Visual Basic for Applications), Format Series dialog, rotating and exploding charts 401—403
VBA (Visual Basic for Applications), Format Series dialog, secondary axis settings 400—401
VBA (Visual Basic for Applications), Layout ribbon changes with SetElement method 375—379
VBA (Visual Basic for Applications), line continuation 364
VBA (Visual Basic for Applications), macro recorder and 360
VBA (Visual Basic for Applications), multiple charts, printing 418—420
VBA (Visual Basic for Applications), new features 365
VBA (Visual Basic for Applications), object variables 363
VBA (Visual Basic for Applications), object-oriented code 361
VBA (Visual Basic for Applications), objects, referencing with With and End With statements 364
VBA (Visual Basic for Applications), pivot charts, creating 416—420
VBA (Visual Basic for Applications), ranges of data, specifying 361—362
VBA (Visual Basic for Applications), template chart types, specifying 372
VBA (Visual Basic for Applications), tips for 359—360
VBA (Visual Basic for Applications), variables, declaring 363
VBA (Visual Basic for Applications), Visual Basic Editor 358—359
VBA (Visual Basic for Applications), Watch window, object settings, finding 410—414
VBA (Visual Basic for Applications), Watch window, rotation settings, finding 413—414
Venn diagrams (SmartArt) 336—337
Vertical axis 52
Vertical axis title 39
Vertical axis, built-in options 53—54
Vertical axis, defined 39
Vertical axis, gridlines/labels, rogue XY series as 230—236
Vertical axis, scale, changing 56—59
Vertical axis, secondary axis, inserting 74
Vertical gridlines 39
Viewing gridlines 59—60
Villella, Kathy 165—167 432
Visual Basic Editor 358—359
Visual Business Intelligence blog 435
Visual design stores 435
Visual Explanations: Images and Quantities, Evidence and Narrative (Tufte) 434
Visualizations, color scales 288
Visualizations, color scales, converting to monochromatic 288—289
Visualizations, color scales, troubleshooting 290
Visualizations, data bars 282
Visualizations, data bars, benefits/limitations 284—285
Visualizations, data bars, customizing 282—284
Visualizations, data bars, for subset of cells 286—287
Visualizations, data bars, size of smallest/largest bar 284—285
Visualizations, icon sets 290—291
Visualizations, icon sets, aligning with numbers 292
Visualizations, icon sets, reversing order of 293
Visualizations, icon sets, setup 291
Visualizations, types of 281
VLOOKUP function 247—249
Volume (of stocks traded) in candlestick charts 210—211 213—216
Volume (of stocks traded) in candlestick charts, creating manually 211—213
Volume (of stocks traded) in high-low-close charts 203—208
Volume (of stocks traded) in line charts 194—197
Walls (3-D charts), defined 40
Walls (3-D charts), formatting 65—66
Watch window, object settings, finding 410—414
Watch window, rotation settings, finding 413—414
Waterfall charts 144
Waterfall charts, creating 144—146
Web connections, creating live stock charts with 216—218
Webpages, exporting charts to 355
Websites, charting tutorials 434
With statement 364
Woodbridge, George 167
Word, copying charts to 347—349
Word, copying charts to, as linked object 352—353
Word, copying charts to, as live chart linked to copy of workbook 350—351
Word, copying charts to, as live chart linked to original workbook 349—350
Word, copying charts to, as picture 351—352
WordArt 318 342—343
WordArt, converting text to 74
Worksheets, moving charts between 224—225
X rotation (3-D charts) 66
X-axis (horizontal axis) 52
X-axis (horizontal axis), axis types, selecting 85
X-axis (horizontal axis), built-in options 52—53
X-axis (horizontal axis), date-based axes, accuracy of 84
X-axis (horizontal axis), date-based axes, converting text to dates 86—92
X-axis (horizontal axis), date-based axes, converting to text 100—103
X-axis (horizontal axis), date-based axes, dates prior to 1900 93—97
X-axis (horizontal axis), date-based axes, displaying as time-based axes 98—100
X-axis (horizontal axis), date-based axes, numeric years as dates 92—93
|
|
|
Ðåêëàìà |
|
|
|
|
|
|