Highlighting Min and Max on the Line chart

[vlad_komarov]

I may be missing something, but I was not able to find an option to highlight the Min and Max value on regular Line Chart. It exists by default on Mini Chart (attached), but I would need to do the same presentation on the regular chart as well.

Any suggestions?

Best regards,

Vladimir

[#2]

you could use reference lines to indicate the maximum and minimum

[johnw · Accepted solution]

You're not missing anything. So far as I know, it isn't directly supported, so you'll have to fake it.

Add extra expressions for the min and max, defined such that the value is only non-null when at the min or max. Using rank() seems simpler than checking for min and max directly, though. Display these new expressions as symbols instead of lines. See attached file and example expressions below:

if(rank(-sum(F2))=1,sum(F2)) // min value
if(rank( sum(F2))=1,sum(F2)) // max value

[vlad_komarov]

Yes, it might work for one line charts, but I can have up to 10 lines in there, so it will not look too good....

[vlad_komarov]

John,

As always, clear and simple!

Exactly what I've asked for.

Thanks!

Regards,

Vladimir

[johnw]

Except that my solution won't work well when you have multiple lines. Or does it? I assumed you meant you had a second dimension, and line charts pretty much allow for two dimensions or multiple expressions, but not both. So using extra expressions to highlight the min and max doesn't seem like it would work in that case. Or maybe it does in v10? Or maybe I'm just wrong?

[vlad_komarov]

John,

I can live with one dimension for this exercise, so your solution works perfectly for multiple lines. The only issue so far is to sync colors for all line's symbols, but it's manageable .

I will upload a modified sample for the record shortly.

Thanks!
Regards,
Vladimir

[johnw]

One thing that may help with synchronizing the colors is to use background color expressions instead of the default chart colors. I almost did that in the example, but for a single line, it seemed easier to just put the colors on the Colors tab.

Edit: I thought of a simplification. If your line has a label of 'Y', then the other expressions can refer to that label instead of repeating the expression:

if(rank(-Y)=1,Y)
if(rank( Y)=1,Y)

Won't matter much for something as simple as sum(F2) like in the example, but may simplify real world problems quite a bit.

[vlad_komarov]

Thanks, John.

Here is the updated example with your original code but for multiple lines and synchronized colors.

Thanks again for your help.

Regards,

VK

[#10]

what u will do in case, the dimension has values more than 10,lets say upto 100....i think in that case it will not be appropriate to use this max & min