Good morning,
I have a chart that represents a total amount of reasons of delay of 4 companies.
in total.
Does anyone know how I can split the bars, to represent how much each company represents in total delays?
If necessary send the file.
Dude, good morning! First you need to convert your table into percentage. I divided the values (from the first column, for example: 330, 669, 3 and 0) into the total (Ex: 330/1002) and I used the percentage button to format it correctly. So in the first example we would have the percentages of 33%, 67%, 0.3% and 0% + - Fromthesepercentages,Icreatedthechartusingthecolumns>columnsthattransformeachcolumnofyourtableintoacolumnofthechart,separatingthecolumnsandcolumnsbycolor,keepingthepercentageastheverticalaxis.
Then you just need to format to appear (or not) the 0% etc.
I hope I have helped!