1 Reply Latest reply on Sep 12, 2019 4:24 PM by kevin flerlage

    Stacked bar with blended axes

    Ani p

      Hi Team,

       

      I have a view like below.

       

      Need to build stacked bar with 3 metrics which are coming from different sources.

       

      I could with 2 metrics with dual axes. but i could not add 3rd one.

       

      CAn you please help me on this?

       

       

        • 1. Re: Stacked bar with blended axes
          kevin flerlage

          I downloaded your three worksheets and it appears two are identical and the third is very different.   First, I would not recommend doing a stacked bar chart for three different measures.  For example, I would not recommend doing a stacked bar of quantity, sales, and profit.  If you wanted to do a stacked bar chart of sales across three categories, that makes sense, but three different measures should probably remain in three different bar charts.  Now if they are measuring the same thing, i.e. your F2 category is measuring, for example, quantity in all three sheets, then you could simply union them then do a stacked bar chart on the values of those three sheets (tablename) on detail.

           

          If you can provide more information on whether the F2 value is the measuring the same thing or different things, that would be helpful.