My Excel data looks like this: (it's a lot bigger in fact)
code1 code2 01/08 02/08 X A 12 10 X B 8 15 Y A 52 0 Y B 5 5
Every day I add a column with extra data (the output of a SQL statement).
A chart with 4 series (X-A, X-B, Y-A and Y-B) and the dates on the X-axis, is easy.
I even found an elaborate solution to make the chart grow as I add dates, but it's hard creating charts for "All Y's" or "All A's".
I could start creating subtotals separately, and charting those, but that's such a maintenance drag.
I've been told not to think of Excel as either a database, report generator or some kind of application deployment mechanism.
But can I get this happening in Excel 2003? Or do I have to look at another charting/reporting tool?
(I would not looking for a Crystal Reports solution if that was the alternative, just something lightweight Office-like.)