View original (French)

How to reduce the number of points on a chart?

Paard Posted messages 3 Status Member -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,
Let me explain my problem to you:
As part of a biomechanics angle measurement project over time, I need to use Excel to obtain a graph representing the angle measurement over time. The only issue is I have an scale of 1250 rows (1250 different measured angles) and I would like to obtain only 100 points on my curve.
How can I do that? :)
Thanks in advance for your answers!

4 answers

  1.
    Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
     
    ... you can especially request a curve trace without markers!
    I think it’s these markers that make your graph unreadable.
    If you send us the Excel file, we can better advise you... 
    1) Go to https://www.cjoint.com/ 
    2) Click on [Browse] to select your file 
    3) Scroll to the bottom of the page to click on [Create the Cjoint link] 
    4) After a few seconds the second page appears, with the link in blue underlined; select it and click "Copy" 
    5) Return to your discussion on CCM, and in your reply message click "Paste".
    Hello to you both.

    --
    That’s nice, retirement! Especially in the Antilles ... :-)
    Raymond (INSA, AFPA, CF/R)
    0
    1. Paard Posted messages 3 Status Member
       
      Hello!
      Thanks for the replies, Raymond I’m sending you the attached link:
      https://www.cjoint.com/c/EDerxjyrpgF

      My graphs are readable, it’s just that my professor told me he wants me to display only 100 points on this curve. Then he mentioned the spline function, but I don’t think this solution is suited to my problem :)
      0
  2. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
     
    Know anyway that CCM forbids doing students' and pupils' work for them:
    https://www.commentcamarche.net/infos/25899-demander-de-l-aide-pour-vos-exercices-sur-ccm/ -> Valid for exercises, homework, reports, projects, theses, ...

    And since the SPLINE function does not exist in Excel (perhaps, I don’t know, in VBA), I would not be able to help you.
    I strongly recommend you consult your fellow students ...
    --
    Nice retirement! Especially in the Antilles ... :-)
    Raymond (INSA, AFPA, CF/R)
    0
  3. Paard
     
    I didn’t ask for someone to do my work, just that we could help me find a solution to get 100 points.
    But thanks for looking into it for me, Raymond.
    see you later
    0
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      you have another proposal higher up...
      eric
      0
  4. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    You can add a column with: =MOD(ROW(),12)
    add an autofilter and filter on one of the values, that will give you 12 times fewer displayed values.
    eric

    --
    Continual effort leads to success.
    So the more it fails, the higher the chances it will work. (the Shadoks)
    In addition to the thank you (yes yes, it’s done!!!), remember to mark as resolved. Thanks
    -2