I have a line chart which is based on non-numeric data, i.e. a hidden number which provides value but a user-friendly label which provides the terms the users are familiar with. I need to build my chart on the ranked numeric data, but show data labels which the users understand.
For example, consider the data to be:
select null, 'Row '||rownum label, rownum*rownum val
from dual
connect by level < 10
But for each value appearing on the graph, I have an equivalent data item that I want to display; instead of 1 say 'Red', instead of 81 say 'Blue'
I've been playing around with this for a while including generating custom XML at runtime, but just can't seem to change the labels. Any idea?