creating a chart for tracking history prices

[happydz]

Hi
I need to create a chart using excel to track the supplier history prices. To make it easier for you to understand my thread, I'll give an example:
let's say the supplier set a prices for a specific product as following:
Nov 07, 2017 $30
Nov 15,2017 $20
Dec 20,2017 $29

Now, the idea is that I want to enter the new price in the cell without losing the previous price so that in the end of every month I will be able to make a chart of history changes of the prices of the specific product.

I appreciate any help from you

thank you

 

[Macropod]

Cross-posted at:
https://www.excelguru.ca/forums/sho...for-tracking-history-prices&p=35707#post35707
https://www.excelforum.com/excel-pr...ting-a-chart-for-tracking-history-prices.html
http://www.msofficeforums.com/excel-programming/37712-creating-chart-tracking-history-prices.html

Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html