cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
0
LenFi

Y axis should correspond to the total of the stacked columns in the chart

Submitted by on ‎05-30-2023 04:45 AM

"Why is 13K higher than 15K?"

In this graph the column bar shouldn't be higher than 15K on the Y axis because the sum of stacked columns adds up to only 13.2K. The Y axis is higher because it adds up all the numbers in the stacked columns, ignoring the minus sign.

LenFi_0-1685446557863.png

 

Status: Delivered

Hi @LenFi 

You can see the difference in the two screenshots below. When you add a grouping in the legend, the column chart will reflect the values corresponding to the grouping, this time the sum is the sum of the values, but the graph is to reflect the positive and negative values.
But when you remove the grouping, it is reflected in the graph as a sum, so the graph can be consistent with the scale on the left.

vyetao1msft_0-1685498652964.pngvyetao1msft_1-1685498789572.png

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yetao1-msft
Community Support
Community Support
‎05-30-2023 07:12 PM
Status changed to: Delivered

Hi @LenFi 

You can see the difference in the two screenshots below. When you add a grouping in the legend, the column chart will reflect the values corresponding to the grouping, this time the sum is the sum of the values, but the graph is to reflect the positive and negative values.
But when you remove the grouping, it is reflected in the graph as a sum, so the graph can be consistent with the scale on the left.

vyetao1msft_0-1685498652964.pngvyetao1msft_1-1685498789572.png

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses