3 Replies Latest reply: Jun 17, 2016 3:45 AM by Wendy Harrison RSS

    Row Labels on a Combi Chart.

    Wendy Harrison

      Hi Everyone,

       

      Does anyone know how to create row labels on a combi Chart.

       

      When I view the straight table it does not show me what the rows relate too.

      When I view the bar chart with the same figures it shows me the description of each bar.

       

      I would like this description to also appear on the left hand side of the straight chart.  I have tried all different ways for this to appear but am unable to locate how to do this.

       

      I have Totals to the left hand side of the straight chart also.

       

      Kind Regards

      Wendy

        • Re: Row Labels on a Combi Chart.
          Chanty 4u

          canu share ur screen sht fr refernce ?

           

          and what it exct?

            • Re: Row Labels on a Combi Chart.
              Wendy Harrison

              Hi

               

              I am struggling to attach my example so please see below.

               

              My table is like this.

               

              Jan      Feb     Mar     Apr

              198     367     254     287

              39       29       64      53

              25       36       39      18

               

              I would like my straight table to show the labels relating to the results on the left hand side of the straight table like below.

               

              Label         Jan      Feb     Mar     Apr

              Total          198     367     254     287

              Positive      39       29       64      53

              Negative    25       36       39      18

               

              I am unable to work out how to get these labels to appear in the straight table even though I have listed them in my data.  If I do a bar chart then the labels appear at the side of the chart.

               

              Kind Regards

              Wendy

            • Re: Row Labels on a Combi Chart.
              Wendy Harrison

              Hi,

               

              I have managed to get the Labels on my chart by changing it to a pivot table.  However I have now lost my totals per line which I really require for Quarter results and YTD.

               

              Does anyone know how to get Totals per row on a Pivot Table?

               

              Kind Regards

              Wendy