need help in Line Chart??

[soha1902]

Hi All,

I m using one line chart where I am showing sales per year.

Now I want to know is this possible to use two symbols in same line. Suppose if sales is greater then previous year then up trangle and if small then down trangle.

Also Want to know Can we use seprate colors for Line and symbols.

Please help.

[Gysbert_Wassenaar]

You can't use two different symbols. You would have to use two expressions. One with up triangles and one with down triangles.

You can set the colors by clicking on the + in front of the expression select Background Color and enter an expression to calculate the color: if(sum(Sales)<above(sum(Sales)),red(), color(1))

You can't use different colors for symbol and line. But you can use two expressions, one for the symbol and one for the line. That way you can give both different colors.

See attached example.

[soha1902]

Thanks a lot Gysbert. You made my day.

One small question...I am using two expression one for line and one for symbol.

Now its showing two legends. I want to show only line legend and want to hide symbol related legend.

Is this possible???

[Gysbert_Wassenaar]

Nope. You can hide the legend, but not pick and choose which expressions to show in the legend and which to hide.

[perumal_41 · Accepted solution]

Hi Soha,

PFA,try is useful for u  or not

Regards,

Perumal A

[soha1902]

Very Nice.....Thank you very much....