+ Reply to Thread
Results 1 to 3 of 3

min/max lines ?

  1. #1
    Registered User
    Join Date
    12-10-2008
    Location
    somewhere,USA
    Posts
    3

    min/max lines ?

    Its been a while since I have done any charts in excel and thus I can't remember much. I am trying to replace a very complicated (overly so in my opinion) spreadsheet with a much simpler one. I need to create a line chart(with points) based off of a list containing date and value which is simple enough. Where it gets screwy is I need to also have a some sort of min/max lines on the same chart so that I know when I have gone above or below our allowed threshold. I need it to show the points on the chart above/below this line(s). I can't simply decrease the viewable range of the chart as this won't show us when we are out of compliance. I have played around trying to figure it out but like I said I just can't remember what I am looking for. If someone can tell me what it is that I am looking for I can figure out how to do it but I don't even remember what its called.

  2. #2
    Forum Contributor
    Join Date
    10-11-2007
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    251
    I hope the attached file solves your problems.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-10-2008
    Location
    somewhere,USA
    Posts
    3
    That's awesome!

    Thanks for the quick reply. It did take me a minute to figure out what you do did but that is exactly what I needed. Thanks so very much.

+ 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