APEX

Hi

I have a need to geneate charts that combine different series of data displayed as diferent chart types.

For example, I need a scatter chart showing individual points combined with one or more trend lines superimposed.

Anychart, the embedded charting software in APEX is well capable of doing this as shown in this chart:-
http://anychart.com/products/anychart/gallery/sample_178.html#

I have been in touch with the support at Anychart and they confirm that the version of anychart bundled with APEX 4.0 has this capability.

According to them, I need to be able to set the series type for the different series.

But the way charting has been implemented in APEX, all the series types are set to the overall chart type with no capability to set the series types individually.

I have looked at the custom XML option, but this would seem to cover the chart as a whole, not the individual series.

I have looked into the internals of APEX and I find a table "wwv_flow_flash_chart5_series" where the definition of each series is stored, and lo and behold, there is a column "series_type" - but this is always null.

Before fiddling with the internals of APEX, I need any suggestions for setting individual series types (after the first) in the chart, so I can achieve the combination chart.

Thanks as always.

Mike