I've never created a Pivot Table before. Back when I learned how to get around in Microsoft Excel, there was no such thing.
我以前从未创建过一个Pivot表。当我学会如何使用微软Excel时，根本没有这种东西。
I'm trying to follow the tutorial in this post:
我试着按照这篇文章中的教程去做:
How to create a bar graph in Excel 2010 by counts?
如何在Excel 2010中创建一个柱状图?
But my Pivot Chart is blank.
但我的主图是空白的。
I'm just trying to create a simple Bar or Pie Chart to show how many tickets each of our members have sold.
我只是想创建一个简单的条形图或饼形图来显示每个成员卖出了多少张票。
The tickets are numbered. At first, it started simple: Everyone was assigned a consecutive number of tickets (like 1-20, 21-40, etc), then some of our group started outselling others.
票已经屈指可数了。一开始，事情很简单:每个人都被分配了连续的票(比如1-20、21-40等等)，然后我们组的一些人开始比其他人卖得好。
Now, tickets 1-7 might have been sold by the same person, but 8, 15, 18, and 19 were handed off and sold by someone else.
现在，1-7票可能是同一个人出售的，但是8、15、18和19号的票是别人卖的。
I can keep up with it in my Excel spreadsheet, but coming up with a way to display how many tickets each person has sold is proving tricky.
我可以在我的Excel电子表格中跟上它，但是找到一种显示每个人卖出了多少张票的方法是很困难的。
I could probably have this done already if I'd use my fingers and toes, but I want this to be done on the PC, and using Excel.
如果我用我的手指和脚趾，我可能已经完成了，但是我想在PC上完成，使用Excel。
Here's a screenshot showing how far I've gotten. I had to blur the names, because a lot of our members think the Internet is the devil. Maybe it is, but that's a different topic. :)
这是一个屏幕截图显示了我已经走了多远。我不得不把名字弄模糊，因为我们的很多会员都认为互联网是魔鬼。也许是，但那是另一个话题。:)
Could someone walk me through how to get a chart to show all of our members (like Wade with 40 or so, Allan with 20, and Dennis with 0)?
有人能给我介绍一下如何找到一个图表来显示我们所有的成员(像韦德40岁左右，艾伦20岁，丹尼斯0岁)吗?
If a VBA solution is more suited for this, I'd be happy to see how to go about getting one of those to work as well.
如果VBA解决方案更适合这种情况，我很高兴看到如何让其中的一个工作起来。
1 个解决方案
#1
1
Just drag Sold into the Values (assuming that it is a 0 or 1 for if the ticket they have is sold or not)...
(Pivots are a great tool - I recommend playing with a Pivot Table and then making a Pivot Chart... it is easier to see what is going on, in my opinion)
只要将已售出的票拖进值中(假设如果已售出的票或未售出的票是0或1)……(数据透视是一个很好的工具——我建议使用一个数据透视表，然后制作一个数据透视表……)在我看来，更容易看清发生了什么事
#1
1
Just drag Sold into the Values (assuming that it is a 0 or 1 for if the ticket they have is sold or not)...
(Pivots are a great tool - I recommend playing with a Pivot Table and then making a Pivot Chart... it is easier to see what is going on, in my opinion)
只要将已售出的票拖进值中(假设如果已售出的票或未售出的票是0或1)……(数据透视是一个很好的工具——我建议使用一个数据透视表，然后制作一个数据透视表……)在我看来，更容易看清发生了什么事