I have a bar chart with 3 different regions, describing the number of events over the last four weeks. I want to overlay a dashed line showing the average # of events over the same time period. This way, when you drill down into State and City, you see the average # of events for the region over the last four weeks.
Additionally (and similarly), I want another dashed line that describes the "goal" number of events for the time period.
The data is all from the same chart, since it is all regarding the number of events in the last four weeks. However, I don't know where to start. Please help me get pointed in the right direction!