Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-27-2021, 03:49 AM
MikelZU MikelZU is offline How to create a report with a graph showing data from diferent updates/status data Windows 10 How to create a report with a graph showing data from diferent updates/status data Office 2019
Novice
How to create a report with a graph showing data from diferent updates/status data
 
Join Date: Apr 2021
Posts: 1
MikelZU is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-30-2021, 12:19 AM
miless2111s miless2111s is offline How to create a report with a graph showing data from diferent updates/status data Windows 7 32bit How to create a report with a graph showing data from diferent updates/status data Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 32
miless2111s is on a distinguished road
Default

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.
Reply With Quote
Reply

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
How to create a report with a graph showing data from diferent updates/status data 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 create a report with a graph showing data from diferent updates/status data 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft