Hi,

I have a pivottable that contains two columns:
Column A has Dates in it (daily increments), Col B has integer values in it.

I want to be able to plot a chart that will have the values from col B plotted on the Y axis but also have a straight line representing the mean (this should be a constant) and lines for the +/- 2 standard deviations, and +/- 3 standard deviations (these are also constants) i.e. include upper and lower control limits along with the mean.

I am not sure how to include these in the chart without creating series outside of the pivottable. I want to be able to create them within the pivottable if possible so they dynamically update with changes in pivot selections.

Many thanks,

Q