Has any changed the stacking of column chart groupings? | Community
Skip to main content
Level 3
March 23, 2023
Solved

Has any changed the stacking of column chart groupings?

  • March 23, 2023
  • 2 replies
  • 1073 views

I have a report that is y axis is planned hours in sum. x axis planned completion date by month. But it is also grouped column by project status. I want to change the order of how the statuses are stacked. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Madalyn_Destafney

Hi there, charts with stacked bars will sort it in alpha order, bottom to top of the bar. So status A portion of the bar will be on bottom, status Z portion will show on top of the bar. So if you want to change how these show, it would require you to change the status names, which I doubt you'd want to do.

You can work in some text mode or column rules into your report groupings to show a name as something else (like showing a name for report column results in column rules, i.e. show XYZ dates as 'Q1') for the Details view of a report but it will still show as original names in the Chart tab since charts aren't fond of text mode. Hopefully that is something that will change with Canvas.

If you found this helpful, please mark correct to help others : )

2 replies

Rafal_Bainie
Community Advisor
Community Advisor
March 24, 2023

I don't think this will be possible in WF, but maybe someone will prove me wrong...

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity AdvisorAccepted solution
Community Advisor
March 24, 2023

Hi there, charts with stacked bars will sort it in alpha order, bottom to top of the bar. So status A portion of the bar will be on bottom, status Z portion will show on top of the bar. So if you want to change how these show, it would require you to change the status names, which I doubt you'd want to do.

You can work in some text mode or column rules into your report groupings to show a name as something else (like showing a name for report column results in column rules, i.e. show XYZ dates as 'Q1') for the Details view of a report but it will still show as original names in the Chart tab since charts aren't fond of text mode. Hopefully that is something that will change with Canvas.

If you found this helpful, please mark correct to help others : )

If this helped you, please mark correct to help others : )
Level 3
March 24, 2023

That is a good point. I have tried text mode aggregate sorting on the statues, but it didn't change the chart.  I do have a particular status that I need to show up top. I will discuss it with my team, if there isn't any other options.