(电脑表格的制作方法视频教程)(电脑表格怎么制作表格视频)

经验分享——利用Excel制作柱状图和堆积图

LearningYard新学苑

分享兴趣，传播快乐，增长见闻，留下美好！亲爱的您，这里是LearningYard新学苑。今天小编为大家带来经验分享——利用Excel制作柱状图和堆积图。

在数据大爆发的今天，人们不仅仅满足于观察数据本身，更多是对数据进行探索、挖掘、转换，然后可视化数据，使人们方便快捷的观察整个数据的分布的规律，趋势等。数据可视化的工具和软件有很多，今天小编给大家分享的是用Excel做数据可视化。

柱状图

首先，新建一个Excel,用数据透视表计算出各地平均薪资，点击插入，然后点击数据透视表中的表格和区域，点击确定。

把不同字段拖进不同的区域，将地点字段拖进行将年薪字段拖进值，单击求和项年薪，在计算类型中选择平均值，点击确定。

选中其中一栏年薪字段，点击右键选择排序并设为降序。

选中需要的区域，点击插入点击图表，插入柱形图。

柱形图会自动生成，删除不必要的字段。

全选柱状图，单击右键，选择设置数据系列格式，调整柱子间的间距。

点击右上角的加号，取消勾选网格线即可删除背景网格线。

勾选坐标轴，在设置绘图区格式中点击实线，并为其设置颜色，即可将坐标轴实线化。

选中需要突出的柱子，在设置绘图格式中点击填充，点击纯色填充，设置柱状图颜色，可以选择设置突出色。

02

堆积柱形图

重复前面的步骤。

将第三个字段拖进行，将第二个字段拖进列，将第二个字段拖进值。框选需要的区域，插入堆积柱形图。

删除不必要的字段，将坐标轴实线化，设置柱状图颜色。点击设计，选中添加图表，点击坐标轴标题，分别添加纵轴标题，添加横轴标题，并修改标题名称。

Share interest, spread happiness, increase knowledge, leave good! Dear, this is LearningYard's new school. Today xiaobian brings you experience to share -- using Excel to make bar charts and stack charts.

In today's data explosion, people are not only satisfied with observing the data itself, but also explore, mine and transform the data, and then visualize the data, so that people can easily observe the distribution law and trend of the whole data. There are many data visualization tools and software, today xiaobian to share with you is to use Excel to do data visualization.

A histogram

First, create a new Excel, use the PivotTable to calculate the average salary for each location, click Insert, then click the tables and fields in the PivotTable, and click OK.

Drag different fields into different areas, drag location field to Drag annual salary field into value, click sum annual salary, select average in calculation type, and click OK.

Select one of the salary fields, right-click, select Sort and set it to descending order.

Select the desired area and click Insert click chart to insert bar chart.

The bar chart is automatically generated, removing unnecessary fields.

Select all the columns, right-click, select Set Data series Format, and adjust the spacing between the columns.

Click the plus sign with the top corner and uncheck the grid line to delete the background grid line.

To make the axis solid, select the axis, click the solid line in the Format of the Set drawing area, and set the color for it. Select the column to be highlighted, click Fill in Set drawing Format, click Solid Color Fill, and set bar chart color. You can choose to set highlight color.

Pile-up histogram

Repeat the previous steps.

Drag the third field forward, the second field into the column, and the second field into the value. Box the desired area and insert the stack histogram.

Delete unnecessary fields, line up the axes, and set the bar chart color. Click Design, select Add Chart, click the axis title, add the vertical axis title, add the horizontal axis title, and modify the title name.

If you have a unique idea for today's article, feel free to leave a message and let's meet tomorrow. I wish you a happy and happy day!

如果您对今天的文章有独特的想法，欢迎给我们留言，让我们相约明天，祝您今天过得开心快乐！

-END

参考资料：百度百科、商业数据科学导论课堂视频资料、谷歌翻译。

本文由LearningYard新学苑原创，部分图片及文字来源于网络，若有侵权请联系删除。