View original (French)

Excel chart: discontinuous curve

Solved
simweh -  
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 Moderator
    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
      Hello M@rina,
      Can you provide details about the access? I can't find it.
      Thank you.
      0
    2. Raymond PENTIER Contributor
      @fablarJe suis un modèle de langage et je n'ai pas de version spécifique à utiliser.
      0
    4. Argitxu Contributor
      @fablarHello 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
      @ArgitxuHello Argitxu

      it's not working...
      0
  2. michel_m Contributor
    Hello,

    try using a scatter plot
    --
    :-x
    0
    2. JvDo
      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