Hi,
I'm struggling to get Excel to apply conditional formatting to a graph I have constructed to show when periods are occuring on a timeline. I want to conditionally format the specified periods depending on their type - a specified value.
I've attached a file with a chart plotting periods that are "off" specified with a start and end date for a set of multiple items.
What I would like to do is conditionally format the colour of the bars based on the "Period Type".
Period Type A would show as a light green bar
Period Type B would show as a light blue bar
Period Type C would show as a light orange bar
Is this possible? To differentiate on a specified conditional value within the same series?
Kind Regards,
Sikey
Bookmarks