cross table load problem

[Anonymous]

hi gurus,

problem in loading excel file(cross table)

plz find the attachment

Thanks in Advance

[jagan]

HI,

Check the following example

Excel File Data:

Department	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Sales	10	20	11	33	44	13	43	56	44	66	55	22
Finance	20	13	14	17	18	19	20	33	22	11	34	22
IT	11	22	35	53	45	62	62	33	22	11	31	11

[Data]:

CrossTable(Months, Amount, 1)

LOAD Department,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     Jul,

     Aug,

     Sep,

     Oct,

     Nov,

     Dec

FROM

[Sample Line Chart.xlsx]

(ooxml, embedded labels, table is [Sheet3]);

Hope this helps you.

Regards,

Jagan.