How do I split a chart bar into "%" in Excel [closed]

0

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.

    
asked by anonymous 03.12.2018 / 13:44

1 answer

1

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!

    
03.12.2018 / 14:10