View original (French)

Graph. stop the curve at the current month

Solved
cg.c Posted messages 196 Registration date   Status Member Last intervention   -  
cg.c Posted messages 196 Registration date   Status Member Last intervention   -
Hello,

Following my first line graphs; the data range is updated daily: numbers in rows and months in columns, according to a separate calculation table but on the same sheet… I use a (IF) formula to reveal the data if the month has passed or is in progress, and "" if in the future. As a result, my graph lines extend horizontally to December, but I want them to stop at the current month… This happens if you enter the data manually in the chart’s reference range, but not if the cells contain a formula to show/hide the numbers… Is there a specific trick? Thank you.

5 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    Maybe with dynamic ranges
    https://www.cjoint.com/c/JGfjIHwV36B

    Best regards
    2
    1. Raymond PENTIER Posted messages 58209 Registration date   Status Contributor Last intervention   17 480
       
      Excellent !
      0
    2. cg.c Posted messages 196 Registration date   Status Member Last intervention   7
       
      Thanks to everyone,
      The events of the time caused me to miss some solutions....
      Would it be possible to put ccm81’s one back online?

      Thanks again
      0
    3. eugene-92 > cg.c Posted messages 196 Registration date   Status Member Last intervention  
       
      Hello,
      You could try this:
      https://cjoint.com/c/KCtg1HcM7ms
      Best regards.
      0
    4. ccm81 Posted messages 11033 Status Member 2 434 > cg.c Posted messages 196 Registration date   Status Member Last intervention  
       
      Just in case, the example of 05/05/2020
      https://mon-partage.fr/f/G9LJHI7M/

      Cdlmnt
      0
    5. cg.c Posted messages 196 Registration date   Status Member Last intervention   7 > ccm81 Posted messages 11033 Status Member
       
      Thank you both,
      I have to transfer to another computer because Excel isn’t on this one....
      and return to the subject
      0
  2. Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   168
     
    Hello,

    why not apply a filter/graph? or even a segment!?
    0
  3. cg.c Posted messages 196 Registration date   Status Member Last intervention   7
     
    ... thank you, but no, I couldn't find what suited me...
    the goal is an "evolving" chart month by month up to December. So today the curve would stop at July... However, with a formula in the reference cells: they are not treated as empty but as having data, so the curve continues through December horizontally at the same height as the last entered value (July)...
    0
  4. Raymond PENTIER Posted messages 58209 Registration date   Status Contributor Last intervention   17 480
     


    Hello.

    You need to modify the data range with the Select data button: it has been done for ...
    --
    It's good, retirement! Especially in the Caribbean ...
    Raymond (INSA, AFPA)
    0
  6. JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
     
    Hello everyone,

    At one time, it was enough to put #N/A in the cells you didn’t want to see on the chart.
    The x-values keep their annual amplitude but the curve only appears for what is not #N/A.

    Best regards
    0