9 Replies Latest reply on Jan 15, 2017 9:56 PM by Khalid Baker

    How can I determine good or bad %s for multiple measures?(Colour code)

    Khalid Baker

      Hi everyone;


      I have an issue determining good from bad as colours. Suppose we are looking at an income statement and creating formulas in excel to look at certain expenses as a % of Net Revenue.


      Suppose I have General & Administrative, Sales Cost, Sales & Distribution as well as Advertising and Marketing expenses each as a % of Net Revenue. Example: General & Administrative/Net Revenue %= 24% for a region1& its 30% for region2, whilst Sales Cost/Net Revenue % = 35% for region 1 & it is 25% for region2.


      To find out what is acceptable or not, we use the following:


      1) For General & Administrative/Net Revenue %, we would say below average General & Administrative/Net Revenue % is acceptable & above average General & Administrative/Net Revenue % would be unacceptable.


      2) For Sales Cost/Net Revenue %, we would say below average Sales Cost/Net Revenue % is acceptable & above average Sales Cost/Net Revenue % would be unacceptable.


      Each expense per net revenue % would have a different average based on the previous logic.


      (This is simplified, of course there are a lot more records/rows)


      I would like to colour code based on previous logic on a single graph/visual.


      Your help is highly appreciated!


      Thanks in advance!


      Kind Regards;