Vintage Analysis Chart

[Dave Sharma]

Hi,

Can someone help me create a Vintage Analysis chart?

I have attached the backup data for the chart. The 2nd file contains a sample of the way I want the chart to look like.

The idea is to understand what happened with each customer in 1 simple chart or picture. I know there are other charts that can depict this but I specifically want it to be like the chart sample I posted here.

Can someone please help me?

Regards,
Dave

 

[GraH - Guido]

Dave Sharma,
Google "Step Chart Excel". Many tutorials/Vids available.

It is a simple line chart, with a little manual tweak. If you would have new data coming in, you'd need to repeat that.
Could be that Jon Peltier has made an add-on for this.

 

[pecoflyer]

Have a look at http://www.andypope.info/charts/stepchart.htm

 

[Hui]

see attached File:

 

[Dave Sharma]

View attachment 56930

see attached File:

This is awesome. Thanks, Hui. Appreciate it. Can you please guide me how you created the left axis where the value and the customer name are together? Regards, Dave