• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    Dual Monitors

    The best way of doing this is to minimize your excel so that you can adjust the size. then drag it from one corner to the opposite end, in a diagonal, then you can go to view in the ribbon, then select Arrange all, then click vertical
  2. G

    picture chart thats graphically shows % complete

    i tried the pie chart. this helps me describe what i am looking for better. the pie chart stays in a circle, i guess what i want is the picture in the background and the picture fill a gradient of the percent complete. like having just an outline of the vehicle and then, lets say 20% is complete...
  3. G

    picture chart thats graphically shows % complete

    sorry, i'm not following how to do that.
  4. G

    picture chart thats graphically shows % complete

    where i work we build vehicles. We have a project that breaks the assembly into 5 sections. each is statused by its self by % complete. is there a way to graphically take those 5 sections and make a chart that shows % complete while having the picture change colors?
  5. G

    Gartner Hype Cycle

    on series, instead of 1, 2, 3 so on, use dates.
  6. G

    Gartner Hype Cycle

    yes you can, you will need table like this. series Type Description Value 1 value 2 1 technology trigger 3D bioprinting 10 10 2 technology trigger Human augmentation 12 12 the series and type are your horizontal axis and your values will...
  7. G

    XML import and export

    Hui, I did what you said, however, the resources don't get properly assigned, the units changed so i worked on fixed work, then the duration changed, reset the durations. However, the work contour wouldn't even paste. I have to go to the usage sheet view and reassign the resources manually...
  8. G

    XML import and export

    I'll try it. thanks
  9. G

    XML import and export

    thank you for the response. The reason is because the schedules are only updated by "Planners," other people who status are not authorized to update and save project files. the solution i need is to go from one group to the "planners" group.
  10. G

    XML import and export

    I am at work and all those sites are blocked. lets just say it is a basic schedule with 5 tasks. Task A through E. each with 100 hours of work. however, i want to export the schedule to excel, then have the control account managers to choose what resources (resources like resource A, and...
  11. G

    Accumulative error

    to Kettlebell, have you tried using the subtotal function. =subtotal(9,A1:A9) for example? for some reason i am not understanding what the 100% is for unless you are trying to weight each task. I do this currently for my work on a very large and complex scale, so if you could maybe describe...
  12. G

    Accumulative error

    you will need a timephased sheet that has every day in the Period of performance. then you will need to take each task and flat spread the task by the amount of duration from start day to finish day. then you can have a total row that will sum the current day and subtract it from the previous...
  13. G

    Format issue

    try changing your "dd-mmm-yyyy" to "hh:mm:ss" and change your procedure to click and not change. it works for me. private sub combobox5_click() combobox5.text = format(combobox5.text, "hh:mm:ss") end sub
  14. G

    XML import and export

    Here is what I am needing. I have a project schedule. I then want people to update thier schedule by adding resource, hours, and work contours. work contours will not import unless it is in an xml file that I have realized so far. I want to be able to take the project schedule, have people add...
  15. G

    XML import and export

    I am trying to import a MS Project schedule into excel, update the information, and then export it back into MS Project via XML format. the problem i have isn't importing, it's exporting back to MS Project in xml format. Any suggestions?
Back
Top