Hi, I'm very new to QV (downloaded Personal Edition yesterday!). I want to experiment with a Financial Control scenario. I have an Excel spreadsheet with 400 rows of various of income and expense headings, and 6 colums representing January to June.The relevant code in my Script looks like this:
LOAD [Nominal Code], [Account Description], Jan, Feb, Mar, Apr, May, Jun, [Jun YTD], F11, F12, F13, F14 FROM (biff, embedded labels, table is [TB 2009_01$]);
How do I create a simple line graph to plot say, Income month by month? When I design the chart, the Dimensions allowable are Jan, Feb, Mar, Apr, May, Jun, etc,. I can only seem to get 1 month's data in my chart at any one time. Also, what Expression do I need to use?
Thanks to anyone who can give me some pointers to get started.