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.

date	id	type	product	Amount sold	Gross rev
13/09/2016	253464	Fruit	productA	22	2
13/09/2016	346342	Veg	productB	44	5
14/09/2016	141234	Fruit	productC	55	11
15/09/2016	24555	Other	productA	11	333
16/09/2016	123122	Veg	productA	5	-4

<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

regards