5 Replies Latest reply: Jul 20, 2010 7:32 AM by Artjoms Tukums RSS

    Top five results and grouping other results.

      Hello

       

      I want to produce a graph which wikl show the top 5 utilised services for an organisation, which i have achieved by using the Max Visible Numer function on the chart properties 'presemntation' tab. However i would like to show a sixth column on my graph to show the total of all other services.

       

      For instance say io requuired a top two in the following scenario:

      Service 1 - 4 Hits

      Service 2 - 3 Hits

      Service 3 - 2 hits

      Service 4 - 1 hit

      I would require the chart to show

      Service 1 - hits

      Service 2 - 3 Hits

      Others - 3 Hits.

      Any Ideas about how this could be acheived ?

       

      Jon