I have a list of different projects with their planned duration days and actual duration days.
Now, I want to show the comparison of each project in the form of grouped chart where there will be two vertical grouped bars one showing planned duration and one showing actual duration of each project.
I created master items for two bars where I am able to assign two different colors for planned and actual duration days but I want to show that for actual duration bar, if planned duration days >= actual duration days then display bar as green color else red color.
Can any one help what is the best way to show such comparison in dash board ? This would help management get an idea about the delay of each task with respect to its planned duration.