Discussion


Note: Images may be inserted into your messages by uploading a file attachment (see "Manage Attachments"). Even though it doesn't appear when previewed, the image will appear at the end of your message once it is posted.
Register Latest Topics
 
 
 


Reply
  Author   Comment  
peter_mikael

Registered:
Posts: 23
Reply with quote  #1 
Hi

I have a table which displays:
1. The top five criteria customers use in order to decide which company to buy from ("drivers") - first column.

2. The customers opinion how well the companies in the market live up to those "drivers". Column 2-7. The percentage indicates how many customers think that the company provides the "driver". Example: Out of 100 people, 45 think that Company A delivers on "Driver 1", but only 4 think that Company F delivers on the same driver.

Customer driverCompany ACompany BCompany CCompany DCompany ECompany F
Driver 145%48%26%26%18%4%
Driver 243%25%32%51%45%4%
Driver 327%34%0%2%15%34%
Driver 435%20%32%18%22%20%
Driver 531%33%2%19%3%18%


How would you visualize this? The goal is to visualize each driver and how the companies compare to each other for that driver. For each driver I especially want to emphasize the top three companies.
peter_mikael

Registered:
Posts: 23
Reply with quote  #2 
Maybe like in this example?

[example17solution]

and somehow highlighting the top three for each driver?
sfew

Moderator
Registered:
Posts: 838
Reply with quote  #3 
Yes, something like the example above should work.
__________________
Stephen Few
peter_mikael

Registered:
Posts: 23
Reply with quote  #4 
We talk about the data in terms of medals.

The company with the highest score on a driver gets a gold medal for that driver, the second highest gets silver and the third highest gets bronze.

How do you suggest incorporating that? Maybe changing color of the bars for the three highest on each driver into gold/silver/bronze or perhaps adding medal icons next to the bars?
bella_gotie

Registered:
Posts: 22
Reply with quote  #5 
medal icons next to the bars
jlbriggs

Registered:
Posts: 200
Reply with quote  #6 
I would add the icon either to the left of the company name, or in a new column to the right of the 'Overall' column.

I would also sort the data to have the highest rank at the top.
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.