see the attached superstore example
it returns this
I needed to use the lod to get the average by product - I through in year just in case you want to look at multiple years
then used what was suggested above to put on a ref line (or avg line)
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Changing the scope has no effect on the line that is drawn.
I changed my calculation and the reference line according to your example. I only receive one plot in my diagram. In your example you are using a bar chart, I am using the shape type. May this be the problem?
I change your workbook to the selection I have in my original workbook.
The average will be calculated per point, but I want a line for each selected product, as shown in the image below.