Stack bar - same color for same event

[kam186]

Hello all,

Stack bar -need same color when event repeating. Default is difference color for repeating event. Anyone can help to resolve this ?
Pls see attachment for detail.

Thanks,
Kam

[Steve=True]

Hi Kam186,

Welcome to the forums.

If you don't need the data separated, you can use a pivot table to sum the values and create a chart from the pivot table.

If you need the data separated, then you may have to try VBA.

Steve=True

[kam186]

Steve, thanks for your feedback.
I need a data separated. Not expert on VBA yet. Can u help me to solve this ?

Thanks,
Kam