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

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.