Forum Discussion
Stacked chart visualization
Hi Antoine_1976 - No worries! You're explaining it clear.
can you check the format pane,
Axis (X-Axis) → Select "Fase y Denominación" (this will create one column per category).
Values (Y-Axis) → Select "CT" (this determines the height of each stacked block).
Legend (for stacking) → Select "Disp./Assy./Man." (this will split each column into stacked segments).
Click on the chart, then go to More Options (⋮) → Sort By → Fase y Denominación.
If it doesn’t appear in the correct order, go to Model View and set a custom sort order using an Index Column.
Make sure "CT" is set to SUM in the Values field.If it's showing only two segments (one for "Assy." and one for "Man."), check your data model.
Try the above suggestions and let know.
Once I tryed you proposal I've got this chart
I've already include a new column in my datasource sheet as #indice (which is simply a number sequence, see below)
| Línea | #indice | Fase y Denominación | CT | objetivo CT | Disp./Assy./Man. |
| Estator BRM Gen2 | 1 | ST 050.000 | 1,4 | 24,0 | Aut. |
| Estator BRM Gen2 | 2 | ST 050.000 | 16,0 | 24,0 | Man. |
| Estator BRM Gen2 | 3 | ST 050.000 | 3,8 | 24,0 | Aut. |
| Estator BRM Gen2 | 4 | ST 050.000 | 0,2 | 24,0 | Man. |
| Estator BRM Gen2 | 5 | ST 050.000 | 1,4 | 24,0 | Aut. |
| Estator BRM Gen2 | 6 | ST 050.100 | 22,2 | 24,0 | Aut. |
| Estator BRM Gen2 | 7 | ST 060.100 | 11,8 | 24,0 | Man. |
| Estator BRM Gen2 | 8 | ST 060.100 | 8,0 | 24,0 | Man. |
| Estator BRM Gen2 | 9 | ST 060.100 | 6,7 | 24,0 | Man. |
The only way I've found for splitting the column was to use #indice as Legend but with the every block of the column is coloured different
Hi All,
Firstly rajendraongole1 thank you for your solution!And Antoine_1976 ,Can you tell me what kind of effect you want with your new #indice addition?
If you feel that the color of your first Aut and Man is not enough to distinguish, you can choose a brighter color for them in the column in the visual, as shown in the picture below, if you want to use indice to distinguish this is not the right indice, because using it to distinguish the stacked blocks will lead to color confusion, and can't be clearly distinguished. “Automatic” and ‘manual’.If you want to use indice to realize other needs, you can contact me at any time, I will receive the message the first time to reply to you, I hope my answer can help you!
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your answer.
Is not about the colours but the sequence. I need the segments to be stacked following the sequence not added by Man. or Aut. and with the same colour for Man. and the same for Aut.
I mean, for ST 050.000 column I need an Aut. segment for 1.4 then another segment for 16.0 after that another one for 3.8 (same color that 1.4 segment) now a segment for 0.2 (same colour that 16.0 segment) and finally another one for 1.4 (which is the 5th listed in the table with the same colour that previously 1.4 and 3.8 segments).