☰

从包含月份和类别列的电子表格生成折线图？

tag-icon • tag-icon microsoft-excel worksheet-function charts
从包含月份和类别列的电子表格生成折线图？

尝试生成一个折线图，显示每月发生某一类别的次数。电子表格包含实例的类别以及发生的月份。这样做简单吗？

例如

**Month **Event
January Logo
January Wedding
January Save the Date
January Save the Date
January Save the Date
January Crest
January Wedding
January Wedding Save the Date
January Wedding
January Crest for Wedding
January Wedding
January Wedding
January Wedding
January Wedding
January Logo
January Editorial
January Crest
January Wedding
January Wedding
January Wedding
January Wedding
January Calligraphy Commission
January Crest for Wedding
January Crest for Wedding
January Wedding
January Wedding
February    Calligraphy Commission
February    Illustrations
February    Wedding Save the Date
February    Certificate Fill-In
February    High End Party
February    Wedding
February    Editorial
February    High End Party
February    Wedding
February    Wedding
February    Save the Date
February    Wedding
February    Crest for Wedding
February    Wedding
February    Wedding
February    Crest

ETC。

答案1

通过使用数据透视表进行计数和数据透视图进行可视化，可以轻松完成此分析。

这是与您的数据相似的成品。

枢轴

设置数据透视表时，您需要确定对MONTH和进行分组的理想方法EVENT。根据它们是两行还是一列一行，可以获得不同的图表。上图是两行。主要区别在于，如果其中一个在列上，条形图的颜色会有所不同。

反复尝试，直到找到自己喜欢的安排。

相关内容