Forum Discussion

acseagers's avatar
acseagers
Frequent Visitor
3 years ago

Change Number Format of Reference Line Data Label for Secondary Y-Axis

I'm trying to create reference lines and corresponding data labels for a line graph that uses a secondary Y-axis.   The two measures have different data types - one is a percentage (e.g. Close Rat...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi acseagers ,

 

According to my tests, this y-axis reference line is for the primary y-axis, because your main y-axis is a percentage, so the reference line is also a percentage. The workaround is to place your percentage measure on the second y-axis and prevent the whole number measure from the primary y-axis.

If you want to keep the percentage axis on the left and the integer axis on the right, the style. There is a "Switch axis position" option that you can turn on.

After the option is turned on, please check below.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

acseagers's avatar
acseagers
Frequent Visitor
2 years ago

Hi Stephen - 

 

Thanks for looking into this!

 

I'm not sure this quite solves my issue as I would like to have reference lines for both the primary and the secondary Y-axis on this graph. It seems that you cannot individually format the data labels for the reference lines even if they coordinate with separate series.