Draw a line betwee points separated by 0

[Gildasl]

Hi,

I am trying to draw a line between points that are separated by some 0. These point are on X axis and represent Quarter.
Each time I tried to use the Excel line, Excel considers an empty cell as o and I do not want the line passing by the 0.

[TABLE="width: 832"]
<colgroup><col style="width:48pt" span="13" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl63, width: 64"]Q1-2010[/TD]
[TD="class: xl63, width: 64"]Q2-2010[/TD]
[TD="class: xl63, width: 64"]Q3-2010[/TD]
[TD="class: xl63, width: 64"]Q4-2010[/TD]
[TD="class: xl63, width: 64"]Q1-2011[/TD]
[TD="class: xl63, width: 64"]Q2-2011[/TD]
[TD="class: xl63, width: 64"]Q3-2011[/TD]
[TD="class: xl63, width: 64"]Q4-2011[/TD]
[TD="class: xl63, width: 64"]Q1-2012[/TD]
[TD="class: xl63, width: 64"]Q2-2012[/TD]
[TD="class: xl63, width: 64"]Q3-2012[/TD]
[TD="class: xl63, width: 64"]Q4-2012[/TD]
[/TR]
[TR]
[TD="class: xl64"]GA[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65, align: right"]148[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65, align: right"]201[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl66"] [/TD]
[/TR]
</tbody>[/TABLE]

Any trick?

Thanks,
Gildas

 

[Trouttrap2]

Set your empty cells to an error type like #N/A. You can do this with a formula. For example =IF(A1=0,NA(),A1) Excel won't graph this error. Therefore you will have a break in your line.

 

[Gildasl]

Hi,

I am trying to draw a line between points that are separated by some 0. These point are on X axis and represent Quarter.
Each time I tried to use the Excel line, Excel considers an empty cell as o and I do not want the line passing by the 0.

[TABLE="width: 832"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl63, width: 64"]Q1-2010[/TD]
[TD="class: xl63, width: 64"]Q2-2010[/TD]
[TD="class: xl63, width: 64"]Q3-2010[/TD]
[TD="class: xl63, width: 64"]Q4-2010[/TD]
[TD="class: xl63, width: 64"]Q1-2011[/TD]
[TD="class: xl63, width: 64"]Q2-2011[/TD]
[TD="class: xl63, width: 64"]Q3-2011[/TD]
[TD="class: xl63, width: 64"]Q4-2011[/TD]
[TD="class: xl63, width: 64"]Q1-2012[/TD]
[TD="class: xl63, width: 64"]Q2-2012[/TD]
[TD="class: xl63, width: 64"]Q3-2012[/TD]
[TD="class: xl63, width: 64"]Q4-2012[/TD]
[/TR]
[TR]
[TD="class: xl64"]GA[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]148[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]201[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[/TR]
</tbody>[/TABLE]

Any trick?

Thanks,
Gildas

I found it. Select the lines, right click-> select "Select data" and THEN click on button "Hidden and empty Cells", it dialog box will propose you what you want to do with the empty cells

 

[Trouttrap2]

I found it. Select the lines, right click-> select "Select data" and THEN click on button "Hidden and empty Cells", it dialog box will propose you what you want to do with the empty cells

That's even better. I forgot about that one. Good job.