I have a set of data -- emails sent per month for various users. So for example, in Nov-11 user "Bob" sent 3 emails. In Dec-14 "Bob" sent 25, "Susie" sent 15, "Michael" sent 5, and "Barbara" sent 10. I would like to have a chart that shows this, with the months being on the x-axis.
I would actually like to produce 2 different versions with the same information. The first will have the x-axis with months only, and each month will have one vertical bar. It will be stacked -- so for Dec-14 Bob will be at the bottom with 25, then Susie with 15, etc. All in one bar. The second will have clusters, so for Dec-14 Bob will have his own column hitting 25, Susie will have her own hitting 15, etc.
I have tried what feels like every possible combination to make these charts in Excel but nothing works! Can someone please help?
I would actually like to produce 2 different versions with the same information. The first will have the x-axis with months only, and each month will have one vertical bar. It will be stacked -- so for Dec-14 Bob will be at the bottom with 25, then Susie with 15, etc. All in one bar. The second will have clusters, so for Dec-14 Bob will have his own column hitting 25, Susie will have her own hitting 15, etc.
I have tried what feels like every possible combination to make these charts in Excel but nothing works! Can someone please help?
