Ãëàâíàÿ    Ex Libris    Êíèãè    Æóðíàëû    Ñòàòüè    Ñåðèè    Êàòàëîã    Wanted    Çàãðóçêà    ÕóäËèò    Ñïðàâêà    Ïîèñê ïî èíäåêñàì    Ïîèñê    Ôîðóì   
blank
Àâòîðèçàöèÿ

       
blank
Ïîèñê ïî óêàçàòåëÿì

blank
blank
blank
Êðàñîòà
blank
Jelen B. — Charts and Graphs for Microsoft
Jelen B. — Charts and Graphs for Microsoft



Îáñóäèòå êíèãó íà íàó÷íîì ôîðóìå



Íàøëè îïå÷àòêó?
Âûäåëèòå åå ìûøêîé è íàæìèòå Ctrl+Enter


Íàçâàíèå: Charts and Graphs for Microsoft

Àâòîð: Jelen B.

Àííîòàöèÿ:

It is easy to create a bad looking chart in Excel. This book teaches you how to unlock the beautiful formatting options available to make incredible looking charts. The first section will talk about how to decide which chart type to use. Subsequent chapters will walk through each chart type, how to create them, how to utilize them, and special options available for each chart. The book discusses themes, colors, creating metallic charts, shadows, transparency, etc. The book also handles anything graphical in Excel. It will show the new In-Cell Data Bar charts available in Excel 2007. A section will talk about creating business flowcharts with IGX Graphics and how to display product pictures in Excel, and a section on VBA will cover creating 100's of charts using the macro language.


ßçûê: en

Ðóáðèêà: Òåõíîëîãèÿ/

Ñòàòóñ ïðåäìåòíîãî óêàçàòåëÿ: Ãîòîâ óêàçàòåëü ñ íîìåðàìè ñòðàíèö

ed2k: ed2k stats

Ãîä èçäàíèÿ: 2007

Êîëè÷åñòâî ñòðàíèö: 480

Äîáàâëåíà â êàòàëîã: 11.12.2007

Îïåðàöèè: Ïîëîæèòü íà ïîëêó | Ñêîïèðîâàòü ññûëêó äëÿ ôîðóìà | Ñêîïèðîâàòü ID
blank
Ïðåäìåòíûé óêàçàòåëü
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
1 2 3 4 5 6
blank
Ðåêëàìà
blank
blank
HR
@Mail.ru
       © Ýëåêòðîííàÿ áèáëèîòåêà ïîïå÷èòåëüñêîãî ñîâåòà ìåõìàòà ÌÃÓ, 2004-2024
Ýëåêòðîííàÿ áèáëèîòåêà ìåõìàòà ÌÃÓ | Valid HTML 4.01! | Valid CSS! Î ïðîåêòå