Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Target Line for clustered Column Chart

I have a dataset with % value. so i choose clustered column chart. 
so here My target is 90% , how to segregate below 90 %  and above 90 % with different color.

Need Help
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    Hi Anonymous 

     

    This can be done by following steps

    then you click on FX item 

    this shold slove your problem.

     

    Did I answer your question? if not please provide more details.Mark my post as a solution! Appreciate your Kudos!!
    Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

    Regards

     

2 Replies

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Solution Sage
    2 years ago

    Hi Anonymous 

     

    This can be done by following steps

    then you click on FX item 

    this shold slove your problem.

     

    Did I answer your question? if not please provide more details.Mark my post as a solution! Appreciate your Kudos!!
    Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

    Regards

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thats great dear, 
    step 1 : select the clustered column chart 
    step 2 : select max line from analytical tab
    step 3: choose column color in visual pane,
    step 4: give the below and above % value then choose color. 

    thats it . 

     

    Thanks dear.