+ Reply to Thread
Results 1 to 1 of 1

Help needed to link graph and months together

  1. #1
    Registered User
    Join Date
    05-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help needed to link graph and months together

    Hi excel users,

    I need some help with a excel file. The problem that i encounter is that i have a graph that will need to trace the last ten days of "slides pending for grading". This graph will help to trace by inputing the dates. However, my current work can only trace to a limited dates(different months not link) and input of dates have to be in different slot for different month. Another thing i would like to fix is that my dates are set to 0.5 days 1 days 1.5days according to day and night. What function should i use so that my vlookup formula in n5 to n26 can trace. i try puting like for example (7.5 (day),8(night)) to (8(day),8(night), however the reading will only look up for the first 8 value that it encounter.
    Problem 1 : Error when input is less than 10 at "chart graph" D2, if can i would like to link the different months together in one chart.
    Problem 2 : Different slot input for different month
    Problem 3 : Date format 7.5 day 8 night confusing, if possible can change it to 8 day 8 night without any problem when vlookup formula is being used.

    Hope you can help me! thanks alot (:
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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