2 Replies Latest reply on Jan 29, 2019 10:16 PM by Denise Delomen

    Adding totals to the end of bars on a stacked bar chart without using a reference line

    Mike Di

      Hi,

       

      So I have a problem that probably has an easy solution. I have a stacked bar chart that counts the number of items and each item has a cost. I want to have the total price on the outside of the end of each bar while the bar is the total number of items. I tried adding a reference line for the total cost, but when I did that it removed all of the bars. I then tried a dual axis with the total items on one x axis and the total cost on the other. I combined the dual axis and tried adding a reference line for total cost. That worked but it wouldn't place the totals at the ends of the bar. They were all over the place. I tried editing the format so that cost was right justified but that didn't work. I don't understand what I'm doing wrong here.