Index

Symbols

#######, dates displaying as, 92

‘ (apostrophe), comments in VBA, 367

_ (underscore) character, line continuation in VBA, 366

2-D exploded pie charts, 126

2-D pie charts, 126

3-D chart elements, 39-40, 67-68

3-D charts

icons for, 13

misleading with, 427-430

rotation, 67-70

3-D exploded pie charts, 126

3-D format settings, formatting in VBA, 393-398

3-D pie charts, 126

3-D rotation in surface charts, 187

3-D rotation settings, formatting in VBA, 388-393

100 percent stacked charts, 132-133

icons for, 12-13

as trend charts, 86

100+ year datasets, date-based axis for, 98-100

1900, dates before, 95-100

A

accessing custom themes, 36

AddChart method (VBA), 367, 368

Adjusted Close column in stock charts, accounting for stock splits,

Get Charts and Graphs: Microsoft® Excel® 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.