+ Reply to Thread
Results 1 to 1 of 1

Progress chart

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    bloem
    MS-Off Ver
    Excel 2003
    Posts
    1

    Progress chart

    Hi guys, I really need help doing a chart.

    First off all, please do excuse my spelling and sentince construction as english is my 3rd language.

    This graph should prefebly be done with conditional formatting and in 20 meter intervals. (seems easier?)
    I need to make a graph visually showing work completed on a road.

    The road gets split up into 20 meter sections and a few layers.
    The data is representing a sertain section on the road, for example the LHS(left hand side) meter 2000 to 2600 and 4000-4100 LHS. (meaning 0-1980 should be clear followed by 2000-2600 colored in and 2620 upon till 3980 should be clear and 4000-4100 color again, all in one line)

    Here is and example I manually made.

    Please help guys, I have been struggeling for a long while to do this and no progress as of yet.
    Even if you can give me a example excel sheet that is almost like this.
    Thank you in advance.

    GraphHelp.jpg

    *Note the road is 62880 meters long and only build in a few hundred meters per day (in different sections)
    Last edited by ijacobs; 04-16-2013 at 02:16 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1