i have created a multi series Bar chart and want to show the series name on top of each -if possible- ( for series name i have added a dummy column in SQL which can be seen below ) , i want to show it without mouse hover ( on mouse hover its working fine but it needs to mouse over on each seriess and user ALSO want to see without need of mouse over and Do Not want to include Legend ). please help.
please note, the SeriesName column has been selected in Column Mapping → Series Name, column acct_name as Label and amount as Value.
SELECT 'Receiving' SeriesName, oat.vmf_name_e as acct_name,
Sum(nvl(vl_cr_amt,0)) amount
FROM vchr_hd, vchr_ln
WHERE vl_acc_code = vmf_code
and vl_org_id = vmf_org_id
AND trunc(vl_pst_dt) BETWEEN :P547_FROM_DATE AND :P547_TO_DATE
AND vl_org_id = :SESSION_BUS_UNIT
AND oat.screen = 1 AND oat.acc_code = '3.01.01'
GROUP BY vmf_name_e
is there any source to follow to make it look better like have gradient colors and / or 3D look etc.? do not want to use PlugIns.
regards