• 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.

Chart to illustrate a group of Customer Payment terms

H

Homsie

New Member
A quick question posed around what is the best way to graphically represent the following data - I have around 700 customers with payments terms (Pre-pay (Zero days) to 60 days)and I want to graphically show this, ideally showing each customer within the graphic. The idea is to show distribution of the terms for all customers.


I am having trouble visualising what it would look like with just one number for each customer - the payment term in days.


Many thanks for any suggestions and ideas
 
You could use a bar plot to display all of the customers in ascending payment terms. This will show a histogram with the distribution of payment terms, but there will obviously be way too many bars to see anything specific about a given customer.


You could then set up a scroll bar form command with a 1-700 range. Put a text box in the graph to reference an offset function to the customer name/number. As you ran the scroll up/down, specific customer information associated with that position on the scroll wculd be displayed in the text box.
 
If you're looking for some type of bell curve, you could have a range of numbers/categories, maybe something like

Prepay

Zero days

15 days

30 days

etc


And then use a formula like this:

=COUNTIF(DataRange,A2)

Then plot as a bar chart with 0 gap width. This would show you what payment term are most being used by your customers.
 
Hi Homsie ,


The others have already given you some suggestions on how to depict the terms for customers ; I'd like to suggest that merely showing a customer's payment terms may not mean much , at least for a commercial manager.


As a commercial manager , I'd be more interested in seeing a customer's payment terms vis-a-vis his business volume ; how much does he contribute to your business in absolute terms ( millions of dollars per year or any other scale of your choosing ) , and how soft are his terms ; someone who takes only 50,000 dollars in business may enjoy 60 days credit , while another with 500,000 dollars in business may enjoy 30 days credit ; of course , this is unusual , but it would be nice to see such abnormalities and do something about them.


Again , it would probably mean more to your business if you could move your million dollar customer from 15 days credit to 10 days credit.


Narayan
 
I like Narayank991's way. that's what i'd do too. And to add 2 cents on top of it you can also include % of breakdown to see where the majority of the breakdown are coming from. So a pie chart in additional to bar charts.
 
Forum Members


Thank you very much for taking the time to offer suggestions - all suggestions I will take away and work with. I'm trying to put together a credit dept dashboard and this element will form a small part of the data to be included.


I would be interested in anyone who has create a dashboard for a credit dept just to see what informstion has been used - and more importantly what reaction the visualasation of the data created.


Once again many thanks
 
Hi Homsie ,


Do you think the Tornado chart will help in your dashboard ? The link is :


http://peltiertech.com/Excel/Charts/tornadochart.html


Narayan
 
You must log in or register to reply here.
Back
Top