1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Different colors for Different Bar Lines in Graph

Discussion in 'Oracle Application Express (APEX)' started by Bharat, Aug 6, 2014.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi All,

    Is it possible to assign different colors for different Bar Lines on the graph based on that Bar Value like below:

    if Value is >90 then Green color
    if Value is >75 and <90 then Blue Color
    and
    if Value is <75 then Red Color
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    If it is, I suspect it will require delving into the Java or XML world.
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    So there is no straight away setup to achieve this right? Can you suggest the Sample XML format to achieve this.
     
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    I don't believe so. I've always been happy w/ the colors displaying as they do...never tried to change them. I'm not at that point w/ APEX where I'm comfortable w/ mucking about w/ its native environment...so I've never tried.

    If you have an OTN account...you might try posting the question on the Application Express forum in the Oracle Community pages.

    CJ
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi CJ,

    We now fixed this issue by doing custom data points with different colors dynamically through function as required.
     
  6. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Really??!!

    How exactly did you accomplish that?
     
  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Wrote procedure to pass data on to the graph and in that procedure provided 4 series and 2 for Bars and 2 for Lines. So achieved Successfully with the exact requirement.
     
  8. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
  9. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Yes CJ, the same way we fixed this issue by doing XML Customization.