There could be times that a man gets challenged to do something that may not be as easy as it seems, and that is exactly what happened to me early last night when my wife challenged me to figure out how to produce the following chart. Painfully I have to admit that I worked on it continuously till 1am and then picked it up again this morning until I got it figured at some 9 o’clock. From now on I would show my sincere respect to those people who use Excel daily — you guys have a sort of tricky tool to “operate”!
Some more info: the chart is based on a data table which has a higher daily target sales, a lower daily target sales, the actual daily booking and the actual daily invoicing, each consists of the Markham data, the Montreal data and the total. (a 4×3 table).