asked on

horizontal bar chart in APEX

Hi All,

I need to create a horizontal bar chart in oracle APEX.In it i need to show payments on x axis and companies on y Axis.it is very easy to plot such horizontal bar charts.But now reuirements have become complex and now i need to show 12 horizontal lines for each company showing payments for each month of the year.

I am not getting this option in APEX please suggest how can i do it.I am using APEX 3.2

Thanks a lot for all the experts.

Sean Stuber

put each month in its own series

January would look like this...

select null,company,sum(payment_amount) payments from your_table
where payment_time >= trunc(sysdate,'yyyy')
and payment_time < add_months(trunc(sysdate,'yyyy'),1)
group by company
order by company

February would look like this...

select null,company,sum(payment_amount) payments from your_table
where payment_time >= add_months(trunc(sysdate,'yyyy'),1)
and payment_time < add_months(trunc(sysdate,'yyyy'),2)
group by company
order by company

then just increment the add_months amount for each of the other series queries

oracle_rookie

ASKER

hi,

Thanks for such a detailed explanation.I think the below chart will work for me:

http://anychart.com/products/anychart/gallery/sample_43.html

Also in my code i am putting year in where condition and i have extracted month and year from date in two separate coloumns.So please let me know what i need to write in my case.

because in this chart on y axis there will be company names in place of p1,p2,p3.......

and there will be 12 series for each corresponding company value.Now will you please guide me how i can make this chart.Also i need to show in the right hand side the month with the color mentioned.

This may be very easy but i am working on Apex first time that's why i am asking such simple questiond.

Once again thanks for your valuable reply.

Regards,
Shyam

ASKER CERTIFIED SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

oracle_rookie

ASKER

Hi sdstuber,

Thanks for your help.I have done my job by your guidance.You have given a perfect solution.Thanks A lot.

Now i will ask another question related to hyperlinking the coloumns items in reports and by clicking on them user navigates to another page where the details behind that number appears.I will ask this question separately.Please help in that also.

Once again thanks alot.

Thanks

oracle_rookie

ASKER

Hi Dear,

Will you please tell me how i can make the format of values shown on x axis of payment to dollar and standard comma format.I am not getting this option in Apex 3.2