cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
APASTORM Regular Visitor
Regular Visitor

How can I adjust automatically the axis of a chart of grouped columns and lines?

Good morning everyone,

 

I know this can be adjust automatically not selecting any beggining or end in the axis settings  but I have found the following problem:

 

1111.PNG

 

  • As you can see in January, the value for the line is 6 while for the column is 4 but the chart is displaying the column over the line when it's value is lower and the same happens in every month until August.

I have tried to set the beggining and the end of both axis with the same permanent value but this solution isn't possible since the values vary every week.

 

Could anyone help me to fix this problem?

 

Many thanks in advanced

 

Adrian

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How can I adjust automatically the axis of a chart of grouped columns and lines?

Hi APASTORM,

It seems that you want to adjust the y-axis's range to be same, right? As I know, it will adjust automatically, we couldm't change its intervel. So I think you could use onle one y-axis, you could close secondary axis like below

500.PNG

Best Regards,
Zoe Zhi

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

 

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: How can I adjust automatically the axis of a chart of grouped columns and lines?

Hi APASTORM,

It seems that you want to adjust the y-axis's range to be same, right? As I know, it will adjust automatically, we couldm't change its intervel. So I think you could use onle one y-axis, you could close secondary axis like below

500.PNG

Best Regards,
Zoe Zhi

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

 

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,302)