Hi Chris,
As you have Excel 2007, I'd got that way:
- remove labels
- add 2 dummy data series for labels only
data for this series could be constructed this way:
B4 and copy to B5: (at the beginning copy this also to I4:M5)
C4 and copy to C5, as well as to right D4:H5 (at the very end copy further right, also to I4:M5, but not now):
now add these 2 new series to your graph, format as labels (see points 1-5) in attachment and middle steps graph in right part of worksheet
And final touch (not shown in attachment, because earlier steps fwould not be visible): copy formula from C4 to I4:M5 (and of course remove comments + extra graphs )
Bookmarks