问题

我在Excel中有一列数据，像这样：

现在我想创建一个柱状图，显示数据在不同范围内的计数，比如范围 1-2 2-3 3-4 4-5 中的数据计数。

> 我在Excel中是新手，完全被卡住了。有人可以指导我该怎么做才能达到这个结果吗？

英文:

I've column of data in excel like this;

Now I want to create bar graph with count of data in ranges. Like count of data in range 1-2 2-3 3-4 4-5.

> I'm a newbie in excel and totally stuck here. Anyone guide me what
> should I do to achieve result?

答案1

得分: 1

一种选择是使用捆绑在Excel中的Analysis Tool-Pak附加组件的直方图功能。

如MSFT所述，适用于Excel版本2007-2013（但仍适用于更高版本）：

英文:

One option is to use the Histogram functionality of the Analysis Tool-Pak add-in that comes bundled with Excel.

As referenced by MSFT for Excel versions 2007-2013 (but still available for later versions):

Make sure you have loaded the Analysis ToolPak.
Add the input data in one column (which you already have) and your bins in another.
Click Data > Data Analysis.
Click Histogram > OK.
Under Input, use the Input Range box for your cells with data and the Bin Range box for your cells with the bins.
Click Chart Ouput.

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。