Reading from Excel files

[Guest_imported]

Hey, I'm fairly new to WebFOCUS, and working on one of my first tasks.
At the moment, I'm trying to create a graph through WebFOCUS from an Excel spreadsheet.
Now, I've had a look at previous pieces of work, and all their excel data is listed in columns, whereas this one is sorted in rows. For example, the previous ones have X and Y as the categories next to each other at the top, and they are listed vertically by month.
This new one has X and Y, one beneath the other, and the values are listed across the row, each column representing a new month.
If I try to read this into WebFOCUS as a master file, it will record each column (month) as a new category. Is there anyway I can get around this (aside from restructuring the excel spreadsheet)?
And if not, is there anyway that I 'rotate' the data, so to speak, using WebFOCUS?

 

[Guest_imported]

Well, I've *sort of* got around the issue by rearranging the data on the Excel sheet, but it's kinda bothersome...

Another question has popped up though - how do I preserve the order of the categories when I'm making a table or graph? For example, I want the order to go from January down to December, but WebFOCUS is being too helpful and sorting them alphabetically - how would I get it to not do that?

If anyone could help me out please, I'd be very grateful.
Thanks in advance. ^_^

 

[FWIT]

One of the things you could try is a defined field. e.g. seq/i1 with month =seq+1; and then go across the seq field. Hope this helps

 

[Guest_imported]

Yeah, I've tried playing around with the Define fields, but to no avail. =Þ

Anyway, I've just created a Macro that copies all the necessary data and rearranges them and told the users that they have to click that Macro at the start of each month to udpate the information. ^_^

Hehe, still works, all good. ^_^