problem with reading from excel format

[Anonymous]

Hi guys

I attached one excel file and two picture of example of my excel and the chart i want to extract from excel

Please let me know how i should change the excel or how i should write script to extract bellow chart from excel?

I will wait to hear from you

thanks

[antoniotiman · Accepted solution]

Hi Elham,

see Attachment.

Regards,

Antonio

[Anonymous]

can you manage problem without changing excel or changing less than your solution?

because each index has many years and each year has a specific items, so the excel get bigger illogically

and also i want a chart for each index separably, how could i choose a index for each chart

[antoniotiman]

Yes, see Attachment.

However I don't know your expected Data Model.

1 Table, 2 Tables, 1 Tables with Distinct Fields (Crosstable)

[Anonymous]

Thanks for your help Antonio

First one was helpful i used that model