Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies