Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multi-series chart setting the series type - combination charts

Mike MacNov 13 2010 — edited Nov 15 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2010
Added on Nov 13 2010
8 comments
4,359 views