Skip to Content

Custom Chart


I need to develop a custom chart with bar and line as shown in below image. (Actual values in Bar and Goal values in line).

In bar I should set color dynamically based on condition if Actual>=Goal set green else red to bar.

Also please help on how to set the thickness of line here and circle.

Can anyone help me on this chart.

Your help would be appreciated.



pastedImage_0.png (12.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Sep 05, 2013 at 05:08 AM

    Hi Padma,

    It is possible to do in condition based colouring in MII Custom Charts


    You need to add conditions at which you want the color of your Bars to change.

    I set 3 conditions on my Pen.1 (which is represented by Bars) to show Green colour when my value of Pen.1 matches 20.00 and 30.00. But these are static hard coded numeric values for colour changing.

    What I could not do (so far) is dynamic condition setting by comparing values from Pen.2 (i.e. 'profit')

    Here is what I got:

    Am not sure yet on how to set an expression based on Pen.1 so that the Pen.2 colours will change.



    Capture.PNG (23.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.