I am trying to display the SUM of each month above each bar. The bar is separated into 3 parts by color. I am trying to use the reference line workaround to display the SUM, but for some reason when I select Line by Cell it is being applied to the whole sheet and not each month. I am not sure why this is happening? Does anyone have any Ideas?
In the screenshot you can see that although I have selected 'Per Cell' it is being applied to the entire Sheet and not per month.
My my main goal is to display the SUM above each bar.
I think you've the continuous fields on both the axes that's why you're getting this result. If you change your date field to discrete you'll get the desired result. Alternatively, you can also turn on labels for each marks.
Hope this helps you.