I've been trying to understand your directions on your website for charting
the last 12 months dynamically and am having trouble translating it to my own
needs. I understand pretty much what you are doing, but my situation is a
little different.
I have data comparing the same week (Mon.-Sat.) from 2007 to the one in
2008. Each week I have data (total call volume) for 6 lines of business. I
want to create a cluster column bar chart with lines of business on the
x-axis and call volume on the y-axis that shows both weeks and updates with
new data for the previous week and the corresponding week from a year ago.
Is this possible?