如何在Excel 2010中创建条形图？ [英] How to create a bar graph in Excel 2010 by counts?

问题描述

我有一列价值观，说出很多A，B，C和D的价值。

我想制作一张图表，显示我们有多少个A，我们有多少个B，这里有多少C，我们有多少D因为某些原因，我执行Insert - > 3d Column graph，然后我尝试选择列中的值（A2到A（一些大数字））。 ，但它就像它不想算什么，它试图将所有的值放在图形的标题中，如ABACDA B ...和图例一样，然后条形图本身只显示一个

解决方案

阅读使用透视图：

过程：

数据透视表：

• 选择数据


• 插入数据透视图


• 拖动值字段到行区域和数据区域作为数值

图表：

• 选择数据透视表


• 插入列图

For whatever reason I can't get this to work right.

I have a column of values, say lots of A's, B's, C's, and D's.

I want to make a graph that shows "Here's how many A's we have, here's how many B's we have, here's how many C's we have, here's how many D's we have.

For some reason I do Insert -> 3d Column graph, and then I try to select the values in the column (A2 to A(some big number)), but it's like it doesn't want to count anything. It's trying to put all the values in the title of the graph, like "A B A C D A B..." and same with the legend, and then the bar graph itself just shows one flat-category at level 0. It makes zero sense.

解决方案

Read on usage of pivot charts:

Procedure:

Pivot Table:

• Select Data
• Insert Pivot Chart
• Drag Value field to Row area and also to Data Area as Count of Value

Chart:

• Select Pivot Table
• Insert Column Chart

这篇关于如何在Excel 2010中创建条形图？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！