Line Chart with different style

[Anonymous]

Hello all,

I want to show a line chart into two style solid and dotted both in alternate way.

I tried to achieve same in Line Style property of Expression tab with If condition but it is doing for mentioned condition only.

But I want to make it follow at alternate level without any condition. Is it possible??

Example : Say I am having Year as dimension and Amount as Sales, now through line chart for year 2009-2010, it shud be a solid line then for 2010-2011 it shud be dotted line and so on...

Pls suggest.

Regards,

Balraj

[fvelascog72]

Hi,

In Expressions Tab you can use in Line Style: if(Year=2010,'<S2>')

[Anonymous]

Sunny,

Two expression means, two different line?

But I want to do it in a single line with a single expression...

[sunny_talwar]

You want some like this??

If yes, PFA

Best,

Sunny

[sunny_talwar]

Did not think of this method. I think this is the answer you are looking for.

[Anonymous]

No,

It should be in a alternate way...

As per your Year Dimension, 2010-2011 is a dotted, then it should repeat for 2012-2013 and then 2014-2015 so on...

[fvelascog72]

Try:

if(Year=2010 or Year =2012 or Year= 2014,'<S2>')

[avinashelite]

try this:

if(Even(Year)=-1,'<S3>')

[sunny_talwar]

Works perfectly Federico Velasco‌. Balraj Ahlawat‌ this gives exactly what you seems to be looking for:

Great job Federico, thanks for showing us this.

Best,

Sunny

[avinashelite]

@fvelascog72 good work