|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to create a report with a graph showing data from diferent updates/status data
hi,
I would like to create a report in MS Project which I can have a graph that contains information from previous days/reports. For example, today is Friday and I have 50% work completed and 20hrs delay, but yesterday I had 40% completed and 18hrs delay, and on Wednesday I had 20% completed and 10hrs delay. CanI create a report with a graph that shows this information per day ? I would like to keep track of the delay and see if we are reducing the delay or not. At the moment I can do it copying the information on an excel sheet, but I would like to know if it is possible to it in Project I hope it is clear Thanks |
#2
|
|||
|
|||
you could do it using some of the custom fields and maybe a macro to overwrite the older data, so maybe you have numbers 1-10 for your delay and 11-20 for the %complete and always copy 9->10 and 8->9 etc so that you are keeping only the last 10 entries but to be honest I would do this in excel as you will be able to keep more data.
You can use a macro to output from MSP to excel. |
Tags |
graph, reporting, tracking |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pop-up window to input data in diferent places of the documment | raspezdal | Word | 1 | 02-22-2017 12:56 PM |
Automatically Organize data in a sheet differently (in order to create a dynamically updated graph) | carlos_cs | Excel | 3 | 05-04-2016 08:44 AM |
Creating a Custom List that Updates when one of the data fields is filtered | anthrus | Excel | 1 | 11-13-2014 11:58 PM |
How to extract data from Excel database to create word report for each patient (row) | nightale | Word | 3 | 07-06-2014 04:17 PM |
How to create a column graph from row data in excel | jyfuller | Excel | 0 | 07-02-2013 05:07 AM |