962
Index
Chart Element drop-down control, 439–440
Chart Layouts option, 437
chart macros.xlsm sample file, 942
chart series feature, 439
chart sheet, 5, 49
Chart Styles option, 437
chart tip, 438
Chart Tools contextual tab, 405, 519, 621
Chart Tools control, 468
Chart type option, 437
ChartObject object, 897
ChartObjects object, 815
charts
axis
category, 452–455
value, 448–452
Chart Area, 443
copying, 414
creating and customizing
choosing types, 409, 412
data views, 411
layouts, 409–411
selecting data, 408–409
styles, 412–413
data series
3-D charts, 464–465
adding, 456–457
changing, 457–460
changing range by dragging range outline, 457–458
combination charts, 465–468
data labels, 460–461
deleting, 456
displaying data tables, 468–469
Edit Series dialog box, 458
editing Series formula, 459–460
error bars, 461–463
missing data, 461
overview, 455–456
trendlines, 463–464
deleting, 414
displaying colors in column, 474–475
elements
adding, 415
Chart Element Control, selecting with, 439–441
Format dialog box, 441–442
formatting, 415–416
keyboard, selecting with, 439
Mini toolbar, 442
moving and deleting, 415
overview, 437–438result, 759
reversing order of, 395–396
selecting
complete rows and columns, 71
multisheet ranges, 72–74
noncontiguous ranges, 71–72
ranges, 70
by searching, 76–78
special types of cells, 74–76
shortcuts for selecting in worksheet, 950–951
Sparkline, 507
summing all in range, 299–300
target, 765
tracing relationships
identifying dependents, 665
identifying precedents, 664
overview, 663
unlocking, 639–640
Center across Selection horizontal alignment option, Format
Cells dialog box, 123
Center command, Ribbon, 14
Center horizontal alignment option, Format Cells dialog box, 123
Center vertical alignment option, Format Cells dialog box, 124
Change All button, Spelling dialog box, 672
Change button, Spelling dialog box, 672
change case.xlam sample file, 942
change case.xlsm sample file, 941
Change Chart Type dialog box, 412, 465–466
Change event, 880
Change History option, Share Workbook dialog box, 632
Change Source button
Edit Links dialog box, 595
Links dialog box, 621
Change Source dialog box, 595
Change worksheet event, 880
ChangeCaseOfText procedure, 909
changing cells, 753, 765
Changing Cells field, Add Scenario dialog box, 756
CHAR function, 234, 932
character codes
CHAR function, 231–233
CODE function, 231
characters
counting
in cells, 243
in ranges, 371–372
in strings, 239
extracting from strings, 240–241
filling cells with repeating, 568
removing from strings, 39060_474877-bindex.indd 96260_474877-bindex.indd 962 3/29/10 11:48 PM3/29/10 11:48 PM