+ Reply to Thread
Results 1 to 1 of 1

Trying to design a very specific graph

  1. #1
    Registered User
    Join Date
    11-04-2011
    Location
    Quebec, Quebec
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Trying to design a very specific graph

    Good morning to all, My fisrt visit here and I want to thank you for accepting me in your community. I am very good with Excel, at leat I taught I was until I came face to face with a problem a collegue submitted to me. Now I need your help resolving this problem. For the sake of the forum, I have reduced the size and complexity of the file. Here is my problem.

    I have a serie of data in 4 colums. Colum 1 has a serie of numbers ranging from -5.0 to 5.0 in a downscaling and upscaling motion. Column 2 is a segment of a whole. Column 3 represents the "X" on a graphic and column 4 the "Y". From this data, I have to extract another serie of data. It needs to be represented in the same way, meaning a segment after the other. I have a different criteria for each segment; for example for segment 1, I need to have all the values that are superior or equal to -1.0 to be extracted. For segment 2, I need to have all the values that are inferior or equal to 3.0 to be extracted. And so on for all segments. The resulting data will be used to design a graph which in it's finality should be sineus. You can refer to my exeample. Thank you very much for your help. have a nice day
    Yugguy
    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