5 Replies Latest reply on Aug 9, 2018 7:41 AM by Joseph Ward

    Plotting pre-calculated confidence bands

    Timothy Dobbins

      Hi all,


      I am trying to plot rates over time by gender (male, female and all). I would like to include 95% confidence intervals for each series in the plot. As these are rates (and our real data are based on small numbers of events), I have calculated the 95% confidence intervals from a Poisson distribution. Calculating the confidence intervals is fine, but I am not sure how to plot them.


      I have found resources to plot intervals for one series:




      but I'm at a loss when there are multiple series on a chart.


      I have attached a sample workbook based on dummy data. I've also attached an image below showing what I'd like to get to (produced in R).


      Any help would be greatly appreciated.






      Screen Shot 2018-06-07 at 4.58.52 pm.png