A question about report design

苏川梁 46

The left main Y-axis is a bar chart, and the right sub-Y-axis is a ratio and a line chart
I want the scale of the secondary Y-axis to be aligned with the scale of the main Y-axis, that is, the scale of the right Y-axis in the figure should be (0.0%, 1.0%, 2.0%, 3.0%, 4.0%, 5.0%, 6.0%), tried There are many ways but can't achieve it, I want to ask for help

Joyzhao-MSFT 15,566 Reputation points

2022-06-28T07:07:28.347+00:00

Do you mean you want the main Y-axis and the secondary Y-axis tick marks to line up?
If I misunderstand what you mean, please feel free to correct me.

1 answer

Joyzhao-MSFT 15,566 Reputation points

2022-06-28T06:52:30.51+00:00

Hi @苏川梁 ,
You can do this by setting the Axis Option in the Secondary Vertical Axis Properties.

In my test, the design before setting Secondary Vertical Axis Properties is as follows:

The preview is as follows:

I set it up as follows:

Preview now：

Best Regards,
Joy

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
苏川梁 46 Reputation points

2022-06-28T07:15:24.937+00:00

Thanks Joy,

I tried your method before, but the minimum value of the Y-axis of my data may be negative, and the maximum value is uncertain, so I have given up, this seems to be impossible, because it is equivalent to two reports, which are different The data.
The following picture is the test result according to your settings：

The image below is for the case of negative numbers, I want 0 to be on the same tick mark.

Joyzhao-MSFT 15,566 Reputation points

2022-06-28T07:41:41.197+00:00

You need to make changes according to your data, for example you want the scale on the right Y-axis should be (0.0%, 1.0%, 2.0%, 3.0%, 4.0%, 5.0%, 6.0%), which is different from my report. When you set the minimum value to 0 and the maximum value to 0.06, the right Y-axis will look like this:

Since my second value (the percentage data for the line chart) is much larger than the maximum scale of my right Y-axis, the line chart is not showing, but your data should be fine.

苏川梁 46 Reputation points

2022-06-28T07:46:12.303+00:00

Thanks
Yes, I can set it like that, but since the data is not fixed, it cannot be set to a fixed value.It seems that this problem cannot be solved

Joyzhao-MSFT 15,566 Reputation points

2022-06-28T08:01:49.833+00:00

I tried negative values and needed to set the Vertical Axis Properties for both the main Y-axis and the secondary Y-axis to make sure they shared, assuming of course I knew the fixed values for my icons. For data that changes over time, it may be necessary to modify the settings multiple times.

Maybe you could consider making the scale interval larger, for example, set the left Y-axis from (-1000~6000) to (-3000~8000), set the interval to 10000; set the right Y-axis from (-0.01~0.06) to (-0.03~0.08), interval is set to 0.01.

We do this just to make the charts more intuitive and beautiful, so please try it several times based on your real-time data.

Joyzhao-MSFT 15,566 Reputation points

2022-06-28T08:10:02.553+00:00

Hi @苏川梁，
If the answer is helpful, please click "Accept Answer" and upvote it.
Warm Regards,
Joy
Sign in to comment