• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

charting with ranks

S

Shabeer

New Member
Hi, I have data as follows

Sales of 10 different line of products which are sold through 3 different channels. Lets say product lines will be soap, shampoo, haircream etc. Channel of distribution are A, B, C class supermarkets. All channels sell all products but sales volumes will differ based on type of product and channel of distribution. I would like to construct a simple chart with ranking of products (highest sale = rank 1, etc) and compare with different channels. Note that Soap for example will be ranked no 1 in channel 1 but might be No 5 in other channel. The idea is to contruct a meaningful chart which captures all the essence. Please help.

regards

shabeer
 
Shabeer


Have you been through Chandoo's tutorial

http://chandoo.org/wp/2008/08/20/create-kpi-dashboards-excel-1/


It might be worth your time.
 
You must log in or register to reply here.
Back
Top