Excel Graph - Overlay Bar Chart & Line Chart, displaying multiple dimensions (geography & time)

Hi experts,

I'm trying to create an Excel chart/graph showing the following (see mock-up image - I got the bars working, but am struggling with the dots/lines):

Grouped by Region we'd like to see:

1) 5 bars (4 bars for the previoius 4 Quarters, and the last bar representing the last month) - that was simple enough to create
2) Within each region I'd like to plot averages on all the bars that represent the previous 4 Quarters (and either display them as dots, or dots connected with a line).

The calculation for the Quarterly averages is quite straight forward (Quarter Value / 3)

Your help would be much appreciated!
Who is Participating?
Ejgil HedegaardConnect With a Mentor Commented:
A bit tricky, but possible.
I have made a description of how to in the sheet.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.