Dynamic Chart

[indygo]

Ok I gave up.




I have a table with very big database. I have Pivot Table and I use filters there etc.
Using example below, can you tell me how I can create 2 Dynamic Line Charts which will show:

- Amount sold and Gross revenue by date for each "type".

- how to create top 5 ranking (dynamic) for product?

I had idea to separate each product and type on separate sheet and create new pivot table and chart - but I failed. Don't know how to extract particular types (Index? vlookup? match?)

Mainly because I can't use top5 for chart...
Top5 Calculation has to be done separately in order to add chart to it.




[TABLE="width: 472"]
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]date[/TD]
[TD]id[/TD]
[TD]type[/TD]
[TD]product[/TD]
[TD]Amount sold[/TD]
[TD]Gross rev[/TD]
[/TR]
[TR]
[TD]13/09/2016[/TD]
[TD]253464[/TD]
[TD]Fruit[/TD]
[TD]productA[/TD]
[TD]22[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]13/09/2016[/TD]
[TD]346342[/TD]
[TD]Veg[/TD]
[TD]productB[/TD]
[TD]44[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]14/09/2016[/TD]
[TD]141234[/TD]
[TD]Fruit[/TD]
[TD]productC[/TD]
[TD]55[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]15/09/2016[/TD]
[TD]24555[/TD]
[TD]Other[/TD]
[TD]productA
[/TD]
[TD]11[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]16/09/2016[/TD]
[TD]123122[/TD]
[TD]Veg[/TD]
[TD]productA[/TD]
[TD]5[/TD]
[TD]-4[/TD]
[/TR]
</tbody>[/TABLE]


regards