The ' Z ' Graph : Sales.. Sales..all the way...

Short, Medium and Long-term Sales analysis - All at once at a Glance !
Sales progress is best shown in graphs.
Here is a consultant's style of showing Long-term, Medium-term and Short-term sales progress - all in one graph. All you need is, sales data for this year till this month, and past 12 Months of sales data.
The magic of the graph is it not only throws light on long-term, medium-term and short- term, it also can show how good is your near future going to be!
Show it only if you have healthy & right data...if you are facing projector lens :-)
If you are the one on the other side of the lens , never forget to ask for this graph ;-)
This is called "Z" Graph.
Now let us see what are these long term, medium term and short term sales progress
Long term sales progress is best represented by Rolling MAT
      MAT - Moving Annual Total (sum of last 12 months data - till this month)
e.g: MAT Jan-11 = Feb-10 + Mar-10 +……+ Dec-10 + Jan-11
      MAT Feb-11 = Mar-10 + Apr-10 +……+ Dec-10 + Feb-11
Medium term sales progress is best represented by YTD
YTD - Year To Date (Cumulative sales starting from the beginning of the year ..say JAN)
e.g. YTD Apr-11 = Jan-11 + Feb-11 + Mar-11 + Apr-11
       YTD Jul-11 = Jan-11 + Feb-11 + Mar-11 + Apr-11 + May-11 + Jun-11 + Jul-11
Short term sales progress is best represented by monthly sales
e.g. Jan-11 , Feb-11 , Mar-11 , Apr-11.....
Bring all the data on to a single graph, it becomes a Z-Graph.
Do not undermine the Graph, the shape of “Z”, the angle inclination, slope of arms of “Z” can through new insights.
“Z” Graph is best for sales dashboards.
Once you plot MAT,YTD and Month, You should get a graph that more or less looks like this…

Red line represents Rolling MAT
Blue represents YTD and 
Green represents Monthly sales
Just to stir your thoughts, here I present you 3 scenarios!
The shape of the “Z” should give you complete picture.

Here is one more idea to explore...
Plot your Months-To-Go and corresponding expected YTD and expected MAT figures as per the Targets/Quotas of Months-To-Go. You may get a perfect "Z" Ora a distorted "Z" like this.....

If the shape of "Z" is... as shown in the picture, it is obvious that risk is a head unless you have a strategy to defy the trends!
All the best!
Download the excel workbook to understand better! Click Here
alternatively @downloads on this website
Its a DO.. CO..MO.. stuff (Download, Copy ,Modify)

Acknowledgements and Reference article by David Straker
One visit to David Straker’s sites will make you a regular visitor.
....In his words….
Syque (pronounced 'sike') is my knowledge sharing site.
My purpose is to share knowledge and understanding on an unprecedented scale, adding real value for individuals and companies. Consider it as 'original books on the internet', with already over 7,000 web pages of industrial-strength knowledge freely available.


  1. "@ John Markham on Pharma SFE & Marketing Forum on LinkedIn commented as follows

    "Even better if you add the year to date sales target as an extra line. I have used Z Charts for many years and they are one of the clearest ways to show how performance is trending against target."

    So added another sheet to Excel showing YTD achievement along with YTD Target. Updated On 13'Oct' 2012"

  2. Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. משרד יחסי ציבור בחיפה

  3. סדנת מכירות קורס המכירות וסדנת המכירות הכי טובים בעולם

  4. Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. קורס מכירות
    Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. קורס מכירות

  5. An advertiser endeavors to produce leads for her sales group. She upgrades change openings over her organization's site, conveys email crusades, fabricates greeting pages and conveys significant gated content.cold call tips

  6. A dynamic, never to be overlooked, business introduction needs to dazzle your group of spectators and be an imperative piece of bringing the deal to a close. They couldn't care less about the moderator, or their sales training or aptitudes, almost as much as they care about themselves and their organization.cold call tips

  7. Sales coaching needs to become part of a company's sales culture just like coaching in sport is a part of the sporting culture. In fact to be effective sales managers need to spend at least 25% of their time with their salespeople in the field coaching.fomo tools