How to create a bar chart with different colors and show as sorted?

[wayne_test]

I'm trying to create a bar chart. But if I just do it by:

index="cn-*"
|top limit=5 SrcIP

The bar chart shows in just single color.

if I do it by:

index="cn-*"
|top limit=5 SrcIP
|eval temp=""
|xyseries temp SrcIP count

The bar chart shows in different colors. But the order seems not sorted by the count.

So, is there any way to create a bar chart with a different color and can it be sorted by the count? Also, I need drilldown at the bar chart.

[niketn · Accepted solution]

@wayne_test try the following:

index="cn-*"
| top limit=5 SrcIP showperc=f
| fields - _*
| transpose header_field="SrcIP"

[wayne_test]

It works! Thanks.