Excel chart - spread different time frames to express as percentage
Solution 1:
If I understand you correctly, calculating the percentages in a separate column and giving these values to chart should solve your problem (Your question would be clearer if you show/upload a sample data).