Getting columns of data from Excel

[#1]

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.

[amit_shetty78 · Accepted solution]

To start off you may need to load the data into QV in using crosstable.

CROSSTABLE(Month, Income, 2)
LOAD [Nominal Code],[Account Description],
[Jan], [Feb], [Mar], [Apr], May], [Jun]
FROM (biff, embedded labels, table is [TB 2009_01$]);

This will give you a table with the following structure when loaded into QV:
Nominal Code, Account Description, Month, Income.

Using this you would be able to create the chart to your liking.

Rgds,
Amit.

[#3]

Many thanks. It worked!