I am trying to insert an average line in a chart. I have read some of the
posts and tried the suggested instructions and I am just not getting this to
work.

I have a column chart that has 11 locations and totals for each, I have
calculated an average - how do I insert an average bar without having to list
the average multiple times so it will go across each of the 11 locations.