Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
i'm trying to make an overview over various Projects working. The problem is that as soon as I add milestones to the phases, it is not possible to show all the data in one line.
The goal is to have something like this:
I managed to have stacked and grouped bar charts to have a timeline. However, the grouped version has not got the possibility to show all the events and phases in one line whilst the stacked version does not interpret the milestones correctly:
Both of the versions were used similarly to the diagramms in this Link: Recipe for a Gantt chart
Has anybody got an idea on how to get close to the screenshot above?
Enclosed you find my qvw-file with the attempts.
Regards,
Max
Thanks for the input!
I managed to get a good result by combining two combi charts (one grouped, one stacked):
The grouped chart for the milestones is an overlay. By adjusting the spaces between the bars the charts have got the same size etc.
Hi Max,
Have you tried creating Milestone with 0 duration or a small duration so that it will show on chart but will be very miniscule compared to other bars.
I'm going to try that for my situation and will update here if it works but just thought of providing idea.
Vijay
Maybe this is helpful: How to create a Gantt chart using a Pivot table
- Marcus
Thanks for the input!
I managed to get a good result by combining two combi charts (one grouped, one stacked):
The grouped chart for the milestones is an overlay. By adjusting the spaces between the bars the charts have got the same size etc.
Hi Max,
Will it be possible for you to attach your QVW? It may be helpful to me for a similar requirement.
Thanks,
Vijay
Hi Vijay,
enclosed you find the qvw with the solution as well as some diagramms from trying to get there. I guess that these could be interesting for you as well.
Regards,
Max
Hi Max,
Thanks for attaching the file. I will look into it. I'm ready to understand it and use it in my situation as I was just able to rearrange my data so perfect timing to get it.
I really appreciate it.
Best Regards,
Vijay
Hi Max,
your solution did help me. I'm including a screen shot from my work.
thanks a lot