Need help creating an SPC chart with filter capability?

Hi All

I am trying to impress the boss with some SPC Charts that can show either a count of all invoices per month or a sum of revenue per month with some 6sigma based analysis lines on the chart.

For this I need a basic line chart that shows the count of invoices accross a few months with a filter per product. Easy enough.

Next I get lost: I need to show a mean of the count of invoices accross all the months. It's easy enough to enter a fixed number, but then it doesn't change as I filter per product.

For all I have:

So the mean is 14680

Then if I filter to product X I get

With mean 276.

So how do I get my graphs to show a horizontal line of the mean that changes as I filter by product?

The next line is the same concept, but the formula is LCL=Mean-(3*StandardDev)

Does anyone know how to create these lines on a line graph?

I also wan't to show all the products with associated revenue on a bar graph, then sort it by amount of revenue so it shows the best performers first.