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.