Need advise on creating pivot table/chart

[onncheng07]

Hi All,


I'm would like to create a pivot table with chart, but unsure where to start from.


Example: I have ordered groceries items from Supplier A and would like to know:


1) the price fluctuation by date for each items.

2) the total quantities ordered

[pre]

Date        Items      Qty           Price
01/03/13    Fish       1.5kg         $20
01/03/13    Potato     0.5kg         $3
01/03/13    Beef       2.0kg         $35
05/03/13    Fish       2.0kg         $25
05/03/13    Eggs       100nos        $5
08/03/13    Fish       1.0kg         $18

[/pre]
Thank you

 

[Faseeh]

Hi onncheng07,


Please see this file:


http://dl.dropbox.com/u/60644346/Simple%20Pivot.xlsx


Faseeh

 

[onncheng07]

Hi Faseeh,


Thanks for the sample file provided.


I have created a pivot table as below:


https://www.dropbox.com/s/n1rq6ytcxapm4zg/Simple%20Pivot.xlsx


There are some questions I would like to ask:


1) How to updates/revised the data after pivot table has created?

2) For the chart which I have created, any other charts format that suit to my data?


Thanks

onncheng

 

[Faseeh]

Hi onncheng07,


For the first question, you can convert your data into Table so that when you refresh your Pivot, it will automatically update things.


Secondly, You can probably use line chart, but that is up to your taste and need.


Regards,

Faseeh

 

[onncheng07]

Dear Faseeh,


Noted and thanks for your help.

 

[Faseeh]

You are welcome onncheng07.


Faseeh