1 Reply Latest reply on Apr 25, 2014 12:24 AM by pe012c

    How do you associate a series to a specific y-axis on a multiple y-axis chart?

    8ffe16c2-26d4-4e1a-bc6f-dcecfd877570

      I am using APEX 4.2.x and would like to know who to associate a series to a specific y-axis in a 2d column chart.

       

      When there are 3 or less series, the graph seems to work like this:

      1) the first series is usually associated with the primary y-axis.

      2) the second series is associated with the additional y-axis.

      3) the third series can be associated to either the primary or additional y-axis. It doesn't matter.

      (see first chart)

       

       

      The problems occur when there are more than 4 series.  By adding a 4th series, the second series is not necessarily associated with the additional y-axis.  (see second chart)

       

       

      By tweaking the XML code

       

        <y_axis name="extra_y_axis_1" position="Opposite" enabled="true">

                    <scale   mode="Normal"  maximum="10" />

       

       

      I can manually change the xml to force additional y-axis to a new maximum.  However, the 4th series does not correspond to the new y-axis. (see third chart)

       

      Does anyone know how to get the 4th series to associate to the additional y-axis?

       

      Here is the example.

      https://apex.oracle.com/pls/apex/f?p=91780:1:21526950465737:::::

       

       

      Thanks.

        • 1. Re: How do you associate a series to a specific y-axis on a multiple y-axis chart?
          pe012c

          Bump..anyone?

           

          The queries for the Bar charts are as follows:

          Series 1 (Total Price): 

          select null link, CATEGORY label, SUM(LIST_PRICE) total_price from "CHARTING"."DEMO_PRODUCT_INFO" group by CATEGORY

           

          Series 2 (Number of Items).

          select null link, CATEGORY label, COUNT(PRODUCT_ID) Number_of_Points from "CHARTING"."DEMO_PRODUCT_INFO" group by CATEGORY

           

          Series 3 (Average Price):

          select null link, CATEGORY label, AVG(LIST_PRICE) Average_Price from "CHARTING"."DEMO_PRODUCT_INFO" group by CATEGORY

           

          Series 4 (Average Price 2):

          select null link, CATEGORY label, AVG(LIST_PRICE)/10 Average_Price2 from "CHARTING"."DEMO_PRODUCT_INFO" group by CATEGORY