Hi all,
What I have is a relatively simple data set. I'd like to graph it so that the Revenue entries appear as clustered columns, and the Cash entries appear as markers right above (or inside) the corresponding revenue column.
Using a combo graph, I'm able to get the columns and markers to show up in the graph. However, all my markers for the first quarter show up in a vertical line in the middle of the 1st Qtr "cluster". I'm trying to get the Region 1 marker to appear in the Region 1 column.
Is this possible? Here's my data. I would include copies of my graph, but I can't figure out how to include that. Any assistance would be appreciated.
Thank you!
What I have is a relatively simple data set. I'd like to graph it so that the Revenue entries appear as clustered columns, and the Cash entries appear as markers right above (or inside) the corresponding revenue column.
Using a combo graph, I'm able to get the columns and markers to show up in the graph. However, all my markers for the first quarter show up in a vertical line in the middle of the 1st Qtr "cluster". I'm trying to get the Region 1 marker to appear in the Region 1 column.
Is this possible? Here's my data. I would include copies of my graph, but I can't figure out how to include that. Any assistance would be appreciated.
Thank you!
Excel 2016 (Windows) 32 bit | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Payer Type | 1st Qtr | 2nd Qtr | 3rd Qtr | 4th Qtr | ||
2 | Region 1 Cash | 62,000.00 | 54,000.00 | 38,000.00 | 41,000.00 | ||
3 | Region 1 Revenue | 47,000.00 | 31,000.00 | 41,000.00 | 44,000.00 | ||
4 | Region 2 Cash | 198,500.00 | 121,000.00 | 126,000.00 | 9,000.00 | ||
5 | Region 2 Revenue | 127,900.00 | 138,000.00 | 131,000.00 | 167,000.00 | ||
6 | Region 3 Cash | 252,400.00 | 266,400.00 | 287,000.00 | 134,000.00 | ||
7 | Region 3 Revenue | 268,100.00 | 234,100.00 | 280,100.00 | 268,000.00 | ||
Rev vs. Cash (2) |