0 Replies Latest reply: Jan 23, 2013 8:16 PM by drwhite72 RSS

    Replicating Scatter Graph from Excel (Boston Consulting Group (BCG) Matrix)

      Can anyone help?

       

      I am trying to replicate the following graph that I produced in excel. The data behind the graph scores applications for business health and technical health based on averaging the scores againest a set of criteria. The criteria are categorised as either business or health related. Therefore I calculate the average business score and average techncial an plot a point on the grid for each application. Excel is difficult to use but I can get to a single view as shown below. What I cant do easily in excel is create an interactive map that enables me to show just the applications belonging to a particular group.

       

      These graphs are sometimes referred to as a Boston Consulting Group (BCG) Matrix, or Boston Consulting Grid.

      Presentation1.jpg