第 1章图表基础 1
1.1 Excel是如何作图的..............................................................................................2
1.2 认识二维表...........................................................................................................5
1.3 认识图..................................................................................................................7
1.4 理解图表类型......................................................................................................10
1.5 作图....................................................................................................................13
1.5.1 一步到位..................................................................................................13
1.5.2 两步到位..................................................................................................15
1.6 总结....................................................................................................................18
第 2章第一招:搞定坐标轴( 1) 19
2.1 坐标轴的传说......................................................................................................20
2.2 坐标轴的记忆......................................................................................................21
2.2.1 谁说坐标轴非得是这样.............................................................................21
2.2.2 这货也是坐标轴........................................................................................22
2.2.3 坐标轴的分类...........................................................................................23
2.2.4“之上”和“之间”的区别....................................................................... 26
2.2.5 刻度的调整——清爽的坐标轴和网格线....................................................29
2.3 涂抹“柏拉图”....................................................................................................32
2.3.1 企业管理、经济分析中的柏拉图分析....................................................... 32
2.3.2 懒人的思考...............................................................................................33
2.3.3 懒人的动手...............................................................................................36
2.4 扩展:对数坐标轴..............................................................................................44
2.5 总结....................................................................................................................45
3.1 认识对称条形图..................................................................................................48
3.1.1 扩展阅读:人口金字塔能读出什么信息....................................................49
3.2 解析对称条形图..................................................................................................51
3.2.1 坐标轴是前进的灯塔................................................................................51
3.2.2 懒人的思考...............................................................................................53
3.2.3 懒人的动手...............................................................................................56
3.3 总结....................................................................................................................60
第 4章第二招:利用辅助列( 1)
4.1 简单装修.............................................................................................................64
4.2 图是想出来的......................................................................................................65
4.3 动手....................................................................................................................66
4.4 简约不简单.........................................................................................................69
4.5 懒人的思考.........................................................................................................72
4.6 懒人的动手.........................................................................................................74
4.7 总结....................................................................................................................81
第 5章第二招:利用辅助列( 2)
5.1 使用次坐标轴......................................................................................................84
5.2 认识堆叠图 .........................................................................................................89
5.3 障眼法................................................................................................................90
5.4 瀑布图(表示如何从开始到结束).......................................................................93
5.5 几个异形瀑布......................................................................................................97
5.6 项目进度甘特图..................................................................................................99
5.7 总结..................................................................................................................103
第 6章小复习:伤不起的面积图
6.1 让人崩溃的面积图............................................................................................106
6.2 面积图的解决之道............................................................................................109
6.2.1 又见坐标轴.............................................................................................110
6.2.2 掀起你的盖头来......................................................................................110
6.3 实战..................................................................................................................111
6.3.1 改造数据 ................................................................................................112
6.3.2 作图........................................................................................................113
6.4 总结..................................................................................................................124
第 7章第三招:用好点和线( 1) 125
7.1 初识散点图.......................................................................................................126
7.2 点和误差线.......................................................................................................127
7.3 几种图和误差线................................................................................................129
7.4 自定义 X轴 Y轴...............................................................................................130
7.5 梯形图(云梯图)..............................................................................................138
7.5.1 补充数据................................................................................................140
7.5.2 制图........................................................................................................141
7.6“天线宝宝”瀑布图...........................................................................................150
7.7 总结..................................................................................................................152
第 8章第三招:用好点和线( 2) 153
8.1 网格图(取代条形图).......................................................................................154
8.1.1 准备数据................................................................................................157
8.1.2 作图........................................................................................................158
8.2 有版权的散点图(魔力象限图).........................................................................162
8.3 增量图——使用高低点连线的折线图............................................................... 163
8.3.1 准备数据................................................................................................164
8.3.2 作图........................................................................................................164
8.4 总结..................................................................................................................167
9.1 雷人的统计数据................................................................................................170
9.2 削峰填谷的平均数和其他..................................................................................171
9.3 箱线图..............................................................................................................173
9.3.1 绘制箱线图.............................................................................................174
9.4 直方图(频数图)..............................................................................................179
9.5 专属 VIP颜料盒................................................................................................182
第 10章做智慧的图
10.1 智慧图............................................................................................................186
10.1.1 先看如何去掉最朴素的智能................................................................187
10.1.2 自动扩展.............................................................................................188
10.2 图的条件格式..................................................................................................196
10.3 可以互动的图..................................................................................................198
10.4 Put AllTogether..............................................................................................203
10.4.1 准备数据.............................................................................................204
10.4.2 制作互动区.........................................................................................206
10.4.3 制作数据表.........................................................................................210
第 11章做正确的图
11.1 分类数据.........................................................................................................214
11.2 整体和部分.....................................................................................................217
11.3 超越整体和部分..............................................................................................218
11.4 再看线图.........................................................................................................221
11.5 饼形图............................................................................................................221
11.6 面积图............................................................................................................223
11.7 总结................................................................................................................224
第 12章不要忘了表 225
12.1 条件格式.........................................................................................................226
12.2 图形字体.........................................................................................................231
12.3 条件格式和图形字体.......................................................................................232
12.4 使用符号.........................................................................................................233
作者简介
张晓明,Oracle数据库专家,常年和海量数据打交道,痴迷于数字可视化。一个没有艺术细胞的“纯理科男”,总妄想用公式、算法做出“一眼瞬间”的美妙图表,随手的工具有Excel、JavaScript。2100433B