Forum Discussion

KD13's avatar
KD13
Icon for Helper I rankHelper I
7 years ago
Solved

Link Line Chart to Different axis in Combo Chart

Hello,

 

i'm workin on a combo char (bars and lines) and i would like link the line charts different axis.

 

Allthe bars are linked to the primary  axis (in millions).

 

i have two lines : (OP) line in million and the other one is  GAP in % and i would like to link the line in million to the primary axis and the line in % to the secondary axis.

 

when i click with the right button on the OP line and i chose move to the shared axis it does not work

Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi KD13 ,

    Could you please check the two line valus are measure or column? If they are measures, the measure could only be applied into the value bucket.

     

    Regards,

    Daniel He

3 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi KD13 ,

    Could you please check the two line valus are measure or column? If they are measures, the measure could only be applied into the value bucket.

     

    Regards,

    Daniel He

    • KD13's avatar
      KD13
      Icon for Helper I rankHelper I
      7 years ago

      Hi v-danhe-msft 

       

      many thanks for your reponse.

       

      they are measures, should i convert to columns in order to be able to switch one of them to the primary axis ?

      • v-danhe-msft's avatar
        v-danhe-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi KD13 ,

        Yes, based on my test, only the column that could be applied to move to the shared axis.

         

        Regards,

        Daniel He