How to create a bi-directional bar chart?

[rajeshjlnt]

I would like to create a bi-directional bar chart. I have 2 fields monthly closed and monthly created tickets, I want to plot a bar chart with 1 field above X axis and another below x axis. I tired all options available in Chart overlay in UI. Also searched for xml code, but with no success.
Can anybody provide some pointers?

[to4kawa · Accepted solution]

| gentimes start=01/01/2019 
| rename starttime as _time 
| timechart span=1month count 
| eval time = strftime(_time ,"%b %Y") 
| table time count
| eval count2=count * -1

Visualization >> Bar Chart
How about this?

[rajeshjlnt]

This is how i want the chart to look but bars below x axis show come with positive numbers :).
My data is created tickets vs closed tickets, so both of them will positive numbers.

[to4kawa]

default Bar Chart can't display strict bi-directional bar chart
In practice, the X axis is negative, but it is displayed.

what's your query?
so both of them will positive numbers.
I see, Finally you can make either one negative.

[rajeshjlnt]

I agree, i got it working by converting on field to negative number. Thank you for the help @to4kawa

[to4kawa]

OK, I see. Happy Splunking.