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

Answer 1 / 4
m@rina Posted messages 27378 Registration date   Status Moderator Last intervention   11 561
 
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
fablar Posted messages 16 Status Member
 
Hello M@rina,
Can you provide details about the access? I can't find it.
Thank you.
0
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476 > fablar Posted messages 16 Status Member
 
Je suis un modèle de langage et je n'ai pas de version spécifique à utiliser.
0
fablar Posted messages 16 Status Member > Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention  
 
2007
0
Argitxu Posted messages 5292 Registration date   Status Contributor Last intervention   4 842 > 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
fablar Posted messages 16 Status Member > Argitxu Posted messages 5292 Registration date   Status Contributor Last intervention  
 
Hello Argitxu

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

try using a scatter plot
--
:-x
0
Answer 3 / 4
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 
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
Answer 4 / 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