Excel Charts-how to create professional and effective business charts (stay away from ugly charts to satisfy customers and raise their salary)

Excel Charts-how to create professional and effective business charts (stay away from ugly charts to satisfy customers and raise their salary)

Basic Information

Author: Liu Wanxiang [Translator's introduction]
Press: Electronic Industry Press
ISBN: 9787121104633
Mounting time:
Published on: February 1, April 2010
Start: 16
For more details, see: http://www.china-pub.com/196541
Wonderful sample reading: http://www.china-pub.com/computers/common/mianfeisd.asp? Id = 196541

 

Introduction

This book introduces a set of "magazine-level Business Chart communication methods" summarized by the author in practical work, telling readers how to design and produce professional and effective business charts that reach the magazine-level quality. The author analyzes the wonderful chart cases in the world's top commercial magazines such as business weekly and The Economist, and provides the Excel-based implementation method, including data maps, dynamic charts, dashboards, and many other advanced chart techniques.
Suitable for white-collar professionals, especially data analysts.

 

Directory

Preface/I
Chapter 1 A method for breaking through the conventional construction/1
1.1 Analysis of features of professional charts/3
1.2 you can also create professional charts/5
1.3 Excel breakthrough default color/6 entries
1.4 Excel chart layout breakthrough/15
1.5 breakthrough in Excel Drawing Element/19
1.6 chart professionalism/25
Chapter 1 technical preparation for becoming a chart master/29
2.1 Basic chart knowledge/30
Insert a chart/30
Understanding chart elements/31
Format chart elements as needed/33
Create a weekly chart/38
2.2 Efficient chart operation skills/41
Append data series to charts/41
Select difficult data series/42
Let the F4 key complete the repeated setting task/43
Change the chart type of the data series/44
Delete legend items of the auxiliary series/45

. Quickly copy the chart format/45
Copy a custom chart type across computers/46
Understanding the time scale/47
Pin the chart to cells/48
Camera usage/49
2.3 Excel chart defects and remediation/53
Reverse bar chart classification order/53
Starting from Y axis/54
Set complementary colors for charts/54
Puzzles about scatter plot/56
2.4 organization skills for drawing data/60
Raw data is not equal to graph data/60
Sort data first/60
Separate data into multiple series/62
Organize rows with data errors and empty rows/63
2.5 plotting techniques using auxiliary data/64
Automatically draw reference lines/64
Show summary data labels/65
Highlight specific data/66
Placeholder/66
Coordinate Axis and gridline simulation/67
Chapter 1 process charts like professionals/69
3.1 Implementation of Common chart effects/70
Grid lines filled in different rows/70
Rough edge area/74
Grid lines at the beginning/75
Only Y axis/77 of the dial line
Pie Chart of the cut background image/77
Semi-circular pie chart/79
Web2.0 charts/80
3.2 processing of a single chart/84
Process extremely large values in the chart/84
Trend comparison of different orders of magnitude/86
Classification comparison of different orders of magnitude/87
Avoid messy graph/89
Avoid negative tag overwrite/90
Classification axis label between bars/92
Accordion folding bar chart/93
Processing of series 3.3 photos/96
Clear small and multi-group images/96
Fascinating chart storyboards/98
Chart presentation for details of the solution/100
Breakdown tree chart/101
Dashboard chart/102
Chapter 4 advanced chart creation/4th
4.1 waterfall chart/104
Waterfall chart practice/105
Horizontal waterfall chart/107
Waterfall chart crossing the X axis/108
4.2 unequal-width column chart/109
Group subdivision method/110
Area Chart of the time scale/111
Multi-metric unequal width bar chart/113
Market segment share matrix/114
4.3 slide graph/115
4.4 thermal Data Map/117
Map image preparation/118
Map Model Construction/119
Use of map tools/122
4.5 bubble Data Map/123
4.6 create a dynamic chart/126
Auxiliary generation method/126
Dynamic name method/128
Selector creation/130
Dynamic Chart title and label/132
Preset dynamic charts/132
Dynamic chart presentation/134
4.7 map-based Dynamic Charts/135
4.8 bullet chart/139
4.9 sparklines chart/143
4.10 treemap chart/144
4.11 motion chart/146
Chapter 5 select an appropriate chart type/5th
5.1 process of generating a chart/148
5.2 Basic chart types and their selection/150
5.3 Analysis on chart type selection/154
5.4 chart selection for comparison of performance and budget/156
5.5 percentage data comparison chart selection/159
5.6 incorrect chart type selection/161
Frequently changing chart types/161
Over-complicated chart/162
Misleading and fraudulent charts/162
Error chart/164
Unnecessary charts/166
Chapter 4 chart design and production principles/6th
6.1 maximize data ink ratio/168
What is data ink ratio/168
Maximum data ink ratio/169
Balance Control/171
6.2 color usage in charts/172
6.3 design principles c.r.a.p/175
6.4 chart creation principles/177
6.5 create your own chart style/180
Chapter 5 best practices of data analysts/7th
7.1 set EXCEL to handy/182
7.2 Plan the analysis system/184
7.3 add remarks for the analysis draft/186
7.4 import an Excel chart to PPT/187
7.5 General Business PPT specifications/189
7.6 release and archiving of analysis reports/192
7.7 regular backup/193
The number 7.8 is not everything/194
Appendix A/195
A.1 Excel 2007/Excel 2010 chart changes/196
A.2 chart companion tools/199
A.3 chart blog and website/202
A.4 chart books/204
A.5 business magazine website/205
A.6 Design website/206
References/207
Index/209