Data out of 100% per Day

[CaitlynV]

I do field observations on crews to improve tool time, and I am trying to create a chart based on the percentage of dark green per day (out of 100% per day), instead out of the whole period (out of 100% for 2 months). There are other grades that count for the rest of the 100% per day, but I am not concerned about that at this moment, only the dark green. Is there a way I can make the dark green percentages out of 100% for the day?

Thanks.

[v-shex-msft · Accepted solution]

HI @CaitlynV,

I'd like to suggest you use 100% stacked column chart to instead.

Drag data column as axis(drill to bottom if date column recognize as hierarchy), amount to value field, category column to legend.

Regards,

Xiaoxin Sheng