topic Time series chart for monthly time line comparison in App Development

Time series chart for monthly time line comparison

Anonymous — Tue, 23 May 2017 21:06:09 GMT

I need to plot number of project started and, project completed comparison in a line chart for every month [And may be if possible number of open project for that month].

Below is the sample data.

Project Id	Project Name	Start date	End date
1	Project 1	3/5/2017	4/5/2017
2	Project 2	4/2/2017	4/25/2017
3	Project 3	4/22/2017	5/15/2017
4	Project 4	5/2/2017	5/21/2017
5	Project 5	5/20/2017	5/30/2017

So number of project started in month of march were 1 and in month of April were 2 and month of May were 2.

Similarly number of project completed in month of march were 0 and in month of April were 2 and month of May were 3.

And optionally, if it can be plot in same graph, the number of open projects for that month in the above example in month of march there was 1 open project (1), in month of Apr there were 3 open project (1,2,3) and in month of may 3 open projects (3,4,5)

Expected graph.

Re: Project completed vs project started monthly time line comparison chart.

vikasmahajan — Wed, 24 May 2017 06:33:58 GMT

you should ideally go for Gantt Chart refer Henric link

Recipe for a Gantt chart

Vikas

Re: Time series chart for monthly time line comparison

Anonymous — Wed, 24 May 2017 15:17:49 GMT

Hi Vikas thanks for the suggestion but here i want to display the stats and not the project hierarchy or timeline.

Re: Time series chart for monthly time line comparison

vikasmahajan — Thu, 25 May 2017 05:45:29 GMT

you can show chart as well and fast change will show stats for the same.

Vikas