I apologise first as similar questions have been asked before, I
guess being honest I just did not understand the answers !
I want to chart share prices with a line chart. I have 20 company
names in A1:T1. Their current prices are imported via another
programme and show in B2:T2.
I have no problem in making a chart showing the company names and
their current prices, but the problem is when the share price
changes. All that happens at the moment is the price is overwritten
and all I see on the chart is the current price (previous price is
lost).
How can I get the line chart to show old prices and the current
price ?
Thanks