MS Project 2010 / Excel Create: S curve and add forecast line based on Remaining work ...

Like totally amazing interchangeable sister outfit accessory swapping or whatever

How to keep bees out of canned beverages?

Normal Operator || T^2|| = ||T||^2

Why these surprising proportionalities of integrals involving odd zeta values?

Are Flameskulls resistant to magical piercing damage?

What is the ongoing value of the Kanban board to the developers as opposed to management

Is Vivien of the Wilds + Wilderness Reclamation a competitive combo?

What's the connection between Mr. Nancy and fried chicken?

Does Prince Arnaud cause someone holding the Princess to lose?

How to break 信じようとしていただけかも知れない into separate parts?

Why do C and C++ allow the expression (int) + 4*5?

Pointing to problems without suggesting solutions

How to leave only the following strings?

How can I introduce the names of fantasy creatures to the reader?

Sorting the characters in a utf-16 string in java

What could prevent concentrated local exploration?

How is an IPA symbol that lacks a name (e.g. ɲ) called?

Who's this lady in the war room?

/bin/ls sorts differently than just ls

A German immigrant ancestor has a "Registration Affidavit of Alien Enemy" on file. What does that mean exactly?

What helicopter has the most rotor blades?

What is the difference between 准时 and 按时?

Does the Pact of the Blade warlock feature allow me to customize the properties of the pact weapon I create?

tabularx column has extra padding at right?



MS Project 2010 / Excel Create: S curve and add forecast line based on Remaining work



Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Add custom colors in Excel 2010Fill handle doesn't work, Excel 2010Excel 2010 Macro to create new sheet, and renameHow to Fix Excel Graph to stop drawing line when data ends (not auto extend line to zero)?Excel 2010 populate based on another sheetExcel 2010, Insert/Create Word Object, Display Page 2 Onlyexcel 2010 add months to 31 day monthexcel 2010 line chart issueBuilding S-Curves for projects in Excel using functions on dates and expected completion percentagesCannot lookup value and create conditional formatting in excel 2010





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















I can created an S curve in excel using planned / actual based on man hours and timescale from Project (task usage, BL hours and Actual hr fields )and put into excel.
I am trying to find a way to use the remaining hours (after changing the status date and Updating Project) but there is no field for that in Task usage. I want to be able to transfer them to excel so that the remaining hours are showing in the timescale used for the S curve and then I can add a forecast line to my graph.



Probably very simple to Super users but I am struggling.



Regards
peter










share|improve this question







New contributor




Peter N is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.



























    0















    I can created an S curve in excel using planned / actual based on man hours and timescale from Project (task usage, BL hours and Actual hr fields )and put into excel.
    I am trying to find a way to use the remaining hours (after changing the status date and Updating Project) but there is no field for that in Task usage. I want to be able to transfer them to excel so that the remaining hours are showing in the timescale used for the S curve and then I can add a forecast line to my graph.



    Probably very simple to Super users but I am struggling.



    Regards
    peter










    share|improve this question







    New contributor




    Peter N is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      I can created an S curve in excel using planned / actual based on man hours and timescale from Project (task usage, BL hours and Actual hr fields )and put into excel.
      I am trying to find a way to use the remaining hours (after changing the status date and Updating Project) but there is no field for that in Task usage. I want to be able to transfer them to excel so that the remaining hours are showing in the timescale used for the S curve and then I can add a forecast line to my graph.



      Probably very simple to Super users but I am struggling.



      Regards
      peter










      share|improve this question







      New contributor




      Peter N is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I can created an S curve in excel using planned / actual based on man hours and timescale from Project (task usage, BL hours and Actual hr fields )and put into excel.
      I am trying to find a way to use the remaining hours (after changing the status date and Updating Project) but there is no field for that in Task usage. I want to be able to transfer them to excel so that the remaining hours are showing in the timescale used for the S curve and then I can add a forecast line to my graph.



      Probably very simple to Super users but I am struggling.



      Regards
      peter







      microsoft-excel-2010 microsoft-project-2010






      share|improve this question







      New contributor




      Peter N is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      Peter N is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      Peter N is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 6 hours ago









      Peter NPeter N

      11




      11




      New contributor




      Peter N is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Peter N is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Peter N is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes












          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "3"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          Peter N is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1428403%2fms-project-2010-excel-create-s-curve-and-add-forecast-line-based-on-remaining%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Peter N is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Peter N is a new contributor. Be nice, and check out our Code of Conduct.













          Peter N is a new contributor. Be nice, and check out our Code of Conduct.












          Peter N is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Super User!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1428403%2fms-project-2010-excel-create-s-curve-and-add-forecast-line-based-on-remaining%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

          Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

          Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...