Microsoft Office Questions? Ask a IT Expert for Support ASAP
Quite a bit of programming will be required for this - you'll need a macro that will copy the current state of the cell and append it into the first empty cell of a given column. Then you'll need to define a dynamic range that always grabs the last x cells of the column. This dynamic range must then be defined for your data series so that the chart can be shown. After that, you can add the color coding, scales, etc. Are you familiar with writing VBA code?
Alternatively, there are lots of free online share tracking tools that work in real time and you can use and customize them to display what you require - https://www.google.com/finance/portfolio