I have support groups and am capturing their monthly ticket counts by analyst in each group. I am trying to show the relationship between the analysts average for a year against the groups' average for the year. This gets updated every month.
I've been asked to plot the average for each analyst against the mean for the group and each standard deviation out to 4 from the mean. So far, I have been able to create a histogram for a sample group and also a distribution curve for the mean and deviations. But I can't marry the two types. I have also tried to create an X-Y Plot graph using the analyst means (not shown) but don't know how to overlay the curve. I believe the point is to show which groups tend to have normal distrubutions and which have non-normal ones.
I believe what I'm looking for is similar to this:
Attached is a sample group with charts so far. This group clearly not normally distrubuted. I've researched EE and other Excel sites and this seems to be a fairly common question but I haven't been able to apply any of the specific solutions.