• 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. J

    Axis Options dialog is missing Axis Type settings (need Date axis)

    I finally got the worksheet data to include proper times next to dates and when I chart the data the horizontal axis does not show the date(s); just some type of unit. Researching, I discovered that when I visit Format Selection for the Horizontal (value) axis, the dialog box for Axis Options...
  2. J

    Data entry and chart of blood sugar readings over time

    Thank you! I am brand new to this forum.
  3. J

    Data entry and chart of blood sugar readings over time

    I want to enter blood sugar levels as a data series that can be plotted so my wife's doctor can see for an upcoming appointment. Her little book shows several readings per day. Here is a snippet from my practice workbook: Date Time Level 1-Sep 08:00 109 1-Sep 12:00 149 1-Sep 16:00 125 1-Sep...
  4. J

    Is vlookup the way to solve this challenge?

    Hi - I discovered my problem. It was in the 2nd parameter to the function: I changed this: =VLOOKUP([grade],ScaleTable[Grades],2,FALSE) to be: =VLOOKUP([grade],ScaleTable[Grades]:ScaleTable[Points],2,FALSE) and it works properly. I think I had misunderstood the...
  5. J

    Is vlookup the way to solve this challenge?

    One workbook with 2 sheets (sheet1 and sheet2). Sheet1 has table called GradeTable. term grade points credits course core 2012D1 D- #REF! 4 SPN-110 01 Elementary Spanish I 2012D1 C #REF! 4 PHY-101 01 Physics for Non-Science Majors NW 2012D1 F #REF! 4 MTH-140 03 Integrated Precalc/Calc I 2012D1...
  6. J

    Is vlookup the way to solve this challenge?

    Thanks for your ideas. Hopefully, I uploaded this properly and you might be able to have a look: https://docs.google.com/open?id=0BwA1QXWV-S3AakQ1cGJ6TG12V0k I simply changed the formula to read: =VLOOKUP([grade],ScaleTable[Grades],2,FALSE) instead of the previous attempt which you...
  7. J

    Is vlookup the way to solve this challenge?

    Thanks, I am getting back to this now and stuck on an "Invalid cell reference error" with the following formula in Sheet1!$C$3 =VLOOKUP([grade],ScaleTable[Grades],ScaleTable[Points],FALSE) I click on the helper wizard and choose "Show calculation steps..". Clicking Evaluate causes this...
  8. J

    Is vlookup the way to solve this challenge?

    I have this "scale" data in sheet2: Grades Points A 4 A- 3.7 B+ 3.3 B 3 B- 2.7 C+ 2.3 C 2 C- 1.7 D+ 1.3 D 1 D- 0.7 F 0 and I have rows like this in sheet1: term grade points credits course core 2012D1 B- 4 SPN-110 01 Elementary Spanish I 2012D1 C+ 4 PHY-101 01 Physics for...
Back
Top