Index
area charts, 476–478
bar charts, 471
box & whisker charts, 484–485
bubble charts, 479, 480
column charts, 469–471
copying, 461
copying formatting, 463
creating
based on template, 522
basic steps, 453–454
combination charts, 518–521
customizing
adding labels, 513–515
adding trendl ines, 517–518
category axis, 506–509
Chart Area, 495–496
Plot Area, 496–497, 496–497
selecting elements, 489–492
using chart customization buttons, 494
using the Format task pane, 493–494
using the Mini toolbar, 495
using the Plot Area, 495–496
using the Ribbon, 494–495
deleting elements, 457–458, 462
elements of, 450–452
embedded. See embedded charts
formatting, 458–459, 462–463
applying, 1022
copying formatting, 500
funnel charts, 487, 488
histogram charts, 481–482
how Excel handles, 446–447
layout, applying, 456
legends, 450, 451, 498–500
limitations, 452
line breaks, adding, 264–265
line charts, 471–473
map charts, 487–489
moving, 460
overview, 445–446
Pareto charts, 483
pie charts, 473–476
PivotCharts, 703–707
preventing from printing, 191–192
printing, 466
properties, modifying, 1022
radar charts, 478–479
renaming, 463
resizing, 460
Sparklines. See Sparklines
stock charts, 479, 481
styles, applying, 456–457
sunburst charts, 485–486
surface charts, 479, 480
titles, 497–498
treemap charts, 486–487
types
modifying, 456, 1021–1022
overview, 466–467
selecting, 467–469
waterfall charts, 483–484
XY charts, 476
Check Accessibility command, 780
check box controls, 14
Check Compatibility command, 780
CheckBox ActiveX control, 991
checkerboard shading, creating, 140
CHOOSE function, 287–288
circular reference errors, 230–231, 424, 435
CLEAN function, 265, 597
cleaning data, 587
adding text to cells, 608–609
changing case of text, 595–596
checklist, 609–610
checklist for, 609–610
classifying values, 598–599
converting values, 597–598
converting vertical data to horizontal data, 603–605
extracting filenames from URLs, 601
filling gaps in imported reports, 606–607
fixing trailing minus signs, 609
identifying duplicate rows, 589
joining columns, 599–600
matching text in lists, 601–602
randomizing rows, 601
rearranging columns, 600–601
removing duplicate rows, 587–589
removing extra spaces, 596–597
removing strange characters, 597
removing text in cells, 607–608
replacing text in cells, 607–608
spell-checking, 607
splitting text, 589–595
from text fields, 265
cleaning text, 866–868
Clear All command, 142
Clear Formats command, 142
Clear Outline, 9