计算日期出现的次数并从中制作图表 [英] Count number of times a date occurs and make a graph out of it

问题描述

我有一个日期列表，其中的每个日期都可以出现多次.我想计算每个日期出现的次数(直方图)并将其显示在图表中(Y 轴是日期出现的次数，X 轴是日期本身)?

I have a list of dates, each date in it can occur more than once. I want to count the number of times each date occurs (histogram) and display it in a graph (with the Y axis being the number of times the date occurs and the X axis being the date itself)?

示例列表:

19/05/2012
19/05/2012
19/05/2012
17/05/2012
17/05/2012
16/05/2012
16/05/2012
16/05/2012
16/05/2012
15/05/2012
15/05/2012
15/05/2012
15/05/2012
12/05/2012
12/05/2012
12/05/2012
7/05/2012

在过去的几年里，我点击了每个菜单选项，但从未找到任何与此相关的内容.这是以某种方式使用数据透视表的情况吗?

I clicked every menu option over the past few years and never did I find anything specific to this. Would this be a case for using PivotTables somehow?

推荐答案

最简单的就是做一个数据透视图.选择您的日期数组(带有标题)并创建一个新的数据透视图(插入/数据透视图/确定)然后在字段列表窗口中，先将日期列拖放到轴列表中，然后再拖放到值列表中.

The simplest is to do a PivotChart. Select your array of dates (with a header) and create a new Pivot Chart (Insert / PivotChart / Ok) Then on the field list window, drag and drop the date column in the Axis list first and then in the value list first.

第 1 步:

第 2 步:

这篇关于计算日期出现的次数并从中制作图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！