I have a report that is generated weekly with productivity numbers for employees in Excel. I am wanting to create a bell curve for several data points where the viewer can select the week time range and the bell curve volition be updated. I have figured out formula wise how to make the mean, standard deviation, norm.dist, etc update when the date range is updated. The issue I have withal to solve or find an answer to though is how to graph this data without having to manually update the ranges of the graphs. Once this is accomplished I'd also like to be able to add vertical lines for the average and one standard deviation on either side of the boilerplate. Is this a possibility in Excel or any other program? I was hoping to exist able to employ Excel, but am happy to explore other options if that's the simply manner to do information technology. Thanks!

asked Sep xxx, 2022 at xx:23

iv

  • Making the graph is easy - y'all just plot all the productivity numbers and they should look like a bell if they are a standard distribution. And then and then the only thing to do is make the vertical lines at the hateful and each standard deviation. How I commonly practice lines is overlay the data nautical chart with a second "100% stacked column" nautical chart that has the same x-axis just the number one for the y-axis (so y'all need a helper column in your data). I volition try to make an example

    Sep 30, 2022 at 20:30

  • Tin can we please have the names of the headers of your information? And info on which of them is the 10-centrality and y-axis of the nautical chart.

    Sep 30, 2022 at 20:34

  • Make the data dynamic then plot that, use another nautical chart overlaid with + and minus 1 sigma .

    Sep 30, 2022 at 20:47