Whale curve Chart

[vishwas]

Hello


Can you please guide me on how to create a whale curve chart for customer profitability analysis?


Thank you in advance

 

[Faseeh]

Hi vishwas,


This is a simple chart, you can follow the graph i found here:


http://www.qlikfix.com/2010/11/10/visualizing-customer-profitability-with-a-whale-curve/


If i workout with the download able data as excel sheet on this page, following procedure will give you a whale chart.


In Col C write CountA(A$1:A1) and drag down

In Col D write SUM(B$1:B1) and drag down


Plot Col C and D, you will get the whale chart

 

[srinidhi]

Check this out well explained,


http://www.ehow.com/how_5766231_create-curve-graph-excel-word.html