Forum Discussion
Multiple Y axes support
- 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
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
I only have one Y-axis to define start and end. Only for the columns, not for the line.
Is this added in a recent release ?
Corne
- Anonymous10 years agoNot applicable
- v-qiuyu-msft10 years agoCommunity Support
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- caantjes10 years agoFrequent Visitor
Hi.
It does not quite work to play with start and end values on the right (and left) axle.
Since it represents growth, the positive and negative need to be above and under all the time.
My assumption now is that this is missing functionality (to align with a certain number, zero).
Any other suggestions?
Corne
- v-qiuyu-msft10 years agoCommunity Support
Hi caantjes,
Horizontal axis value will always display on the bottom of the chart. We are not able to set this axis display in the middle of the chat to separate positive and negative values.
Best Regards,
Qiuyun Yu