大数据 群集_比较Excel群集堆积图中的年度数据

大数据 群集

How can you create a chart from annual or monthly data, and make the results easy to understand? See how to compare annual data in Excel Clustered Stacked Chart -- like a clustered column chart, but with stacked columns, instead of normal ones.

如何根据年度或每月数据创建图表，并使结果易于理解？ 了解如何在Excel群集堆积图中比较年度数据-类似于群集柱形图，但具有堆积列，而不是普通列。

肉类生产的季节性数据 (Seasonal Data for Meat Production)

For example, the table below shows meat production in the UK, per season, over 2 years, in thousands of tonnes.

例如，下表显示了英国超过两年的每季肉类产量，以千吨计。

An Excel clustered stacked chart could show the fluctuations in production for each meat type. Did production change much from 2002 to 2003? For all meat types? Are there seasonal differences in production?

Excel聚类堆积图可以显示每种肉类的产量波动。 从2002年到2003年，产量发生了很大变化吗？ 对于所有肉类？ 生产有季节性差异吗？

聚类堆积图 (Clustered Stacked Chart)

Here is an example of an Excel clustered stacked chart, based on the sample data shown above. We'll see how to create a chart like this, but first we'll look at the two types of charts it's based on -- clustered columns, and stacked columns.

这是一个基于上面显示的示例数据的Excel聚簇堆积图的示例。 我们将看到如何创建这样的图表，但首先，我们将看一下它基于的两种图表类型：聚簇列和堆积列。

创建聚簇柱形图 (Create a Clustered Column Chart)

To start, I'll create