Hi Everbody!
I need to present data in a graph using a primary and secondary axis, this part I know but the data I wish to present is as follows:
The data is a dump from P3e of milestones and their finish date. I need to represent milestones in a graph against date.
For the primary axis I really want a histogram or equivalent to represent the number of milestones per four week cycle (Periods). This will be for planned and actuals.
For the secondary axis I want to present the same data but cumulatively, BUT rather than on a four week cycle, for every instance it occurs in terms of date.
So far I have used a vlookup for Period numbers against the sorted date, then at the end of each month I have counted the number for milestones so that in any period the data occurs on the last day. I’ve used this and the cumulative to give me a graph. This is not ideal as I can’t adjust the columns in the data series, also it become problematic when I try to introduce actuals.
Can some body thing of an easier way of doing this?
I need to present data in a graph using a primary and secondary axis, this part I know but the data I wish to present is as follows:
The data is a dump from P3e of milestones and their finish date. I need to represent milestones in a graph against date.
For the primary axis I really want a histogram or equivalent to represent the number of milestones per four week cycle (Periods). This will be for planned and actuals.
For the secondary axis I want to present the same data but cumulatively, BUT rather than on a four week cycle, for every instance it occurs in terms of date.
So far I have used a vlookup for Period numbers against the sorted date, then at the end of each month I have counted the number for milestones so that in any period the data occurs on the last day. I’ve used this and the cumulative to give me a graph. This is not ideal as I can’t adjust the columns in the data series, also it become problematic when I try to introduce actuals.
Can some body thing of an easier way of doing this?
