Forum Discussion

caantjes's avatar
caantjes
Frequent Visitor
10 years ago
Solved

Multiple Y axes support

  I have a "line and clustered column chart" where the columns display business volume last month and prior month. The line represents percentage growth. The left axle is for the columns and the r...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi caantjes,

     

    It's supported to format both Y-axis for line values and column values in a combo chart. For more information, please see Format the secondary Y-axis section in this article: Tutorial: Customize X-axis and Y-axis properties.

     

    In your scenario, if you have placed one field in Line Values Property in Line and Clustered column chart, then enable the Show Secondary option, you can set properties for those two Y-axis.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

Hi caantjes,

 

Based on my understanding, the growth percentage contains both negative and positive values. And you want to display the negative values under X-axis and positive above X-axis, right?

 

In your scenario, you can specify the both left and right Y-axis start from the same negative values. See:

 

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu