I need your help to build a chart similar to the one below, the idea is to show in columns (Axis Y) information of the process, in the bars the number of days in each of the steps and compare the total with a target. Right now there are displaying 2 steps (Green and Orange) but they could be more.
So far I have try with a bullet chart but it doesnt allow to:
- Include different data in columns in the axis Y (I had to include a table in the left side)
- Display targets in different location depending the value
- Include numbers in the bar that shows the number of days in each step of the process (I add them manually)
Hope you can help me!!!