Question about a chart. There are two measures, one a weighted average (bars) and the other a non-weighted average (dot-marks). The cluster members are business units and the categories are months. The combination chart below produces everything we need except that the dot-markers do not stand directly above their corresponding bar - instead they are all right in the middle for the month. Is there a way to make them go above the corresponding bar (business unit)? Maybe I should be using a different chart entirely?
(http://i300.photobucket.com/albums/nn40/njvree/chart2_zpshlgmogad.png) (http://s300.photobucket.com/user/njvree/media/chart2_zpshlgmogad.png.html)
This ended up being super simple, but for the sake of answering... I had to move BU to the x-axis sub theINV-YYYYMM. This aligned the dots above the business units and not the month.
(http://i300.photobucket.com/albums/nn40/njvree/2015-06-23_11-36-33_zpslh9qs2at.png)