I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the colors dynamically to the sub-categories based on the return values. I mean especially the colors of "WALL"s and "TOP"s of the Bar Graph should change dynamically when there are one or two colors.
Can anybody explain me how to acheive this?