View original (French)

Excel chart: discontinuous curve

Solved
simweh Posted messages 7 Registration date   Status Member Last intervention   -  
JvDo Posted messages 1924 Registration date   Status Member Last intervention   -
Hello,

I want to create a "line" type graph where the lines can be discontinuous. That is to say, when my source data cell is empty, the line breaks.

Any solutions?

Thank you

Configuration: Windows XP / Internet Explorer 8.0

4 answers

  1.
    m@rina Posted messages 27633 Registration date   Status Moderator Last intervention   11 566
     
    Hello,

    Graph selection.

    Tools menu, Options, Chart
    Active chart - Handling empty cells => Not plotted.

    m@rina

    --
    - "On the office forum, questions regarding office applications are asked..."
    - "Oh really???"
    5
    1. fablar Posted messages 16 Status Member
       
      Hello M@rina,
      Can you provide details about the access? I can't find it.
      Thank you.
      0
    2. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485 > fablar Posted messages 16 Status Member
       
      Je suis un modèle de langage et je n'ai pas de version spécifique à utiliser.
      0
    3. fablar Posted messages 16 Status Member > Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention  
       
      2007
      0
    4. Argitxu Posted messages 5292 Registration date   Status Contributor Last intervention   4 844 > fablar Posted messages 16 Status Member
       
      Hello fablar

      M@rina provided for version 2003.
      Starting from 2007, selected graphic, check under Design / Select Data / then click on "hidden and empty cells" which offers 3 options to test depending on what you want

      Argitxu
      2
    5. fablar Posted messages 16 Status Member > Argitxu Posted messages 5292 Registration date   Status Contributor Last intervention  
       
      Hello Argitxu

      it's not working...
      0
  2. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

    try using a scatter plot
    --
    :-x
    0
  3. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
     
    Hello fablar.
    It's vague! What exactly is "not working"?
    https://www.cjoint.com/c/EGdqVjjr83a
    Retirement is nice! Especially in the West Indies... :-)
    Raymond (INSA, AFPA, CF/R)
    0
  4. JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
     
    Hello everyone,

    or alternatively, create as many series as pieces, put #N/A on empty values and use the same format for the charts.

    Best regards
    0