Line Chart - display continuous line when zero value

[#1]

I have a chart with the following data.

x = 1,2,3,4,5,6,7,8,9,10

y = 2,3,2,3,0,0,4,5,3,4

Does anyone know if it is possible to have a continuous line between points 4 and 7 in a similar fashion to Chart 1 Dim 1 = A in the attached doc, though I'd want a similar effect to Chart 3 i.e. dotted line when zero value to represent the anomoly?

Line Style : =IF(SUM({<[Dim 1]={'A'}>}Val)>0, '<S1>', '<S3>')

This is just a simplified example of what would be a standard time-series chart where certain months might be filtered out depending on user selections.

[settu_periasamy]

Hi,

if you add the Dim1 as second dimension, it will give the straight line from 4 to 7, right?

or am i misunderstood?

[#3]

Thanks for the reply.

It's more that I need to enforce the selection of only A in Dim 1 with Set Analytics in Chart 3 but look like you image above but dotted lines on Dim 1 = A between points 4 and 7.