Excel Help!
Thread Starter
Joined: Oct 2000
Posts: 317
Likes: 26
Excel Help!
Hi Everyone
Trying to while away the time in a useful way for once!
I have an Excel spreadsheet relating to the share value of a certain company; this updates whenever I open the sheet and select 'Data' then 'Refresh All.' With this, I only have current information available, but would like to be able to have a graph which tracks the value of these shares on a daily basis.
Does anyone have any clues, please, as to how I could go about doing this?
Thanks, and keep safe!
Trying to while away the time in a useful way for once!
I have an Excel spreadsheet relating to the share value of a certain company; this updates whenever I open the sheet and select 'Data' then 'Refresh All.' With this, I only have current information available, but would like to be able to have a graph which tracks the value of these shares on a daily basis.
Does anyone have any clues, please, as to how I could go about doing this?
Thanks, and keep safe!
Administrator
Joined: Mar 2001
Aviation Qualifications: PPL
Posts: 8,121
Likes: 686
From: Twickenham, home of rugby
To make a graph, you need more than one data point. If your data is constantly being overwritten, then you have only one data point, which makes for a pretty useless graph! If you can store the data in successive columns (or rows), so that day 1 value is column 1, day 2 is column 2 etc, then you can easily create a graph based on the range of columns you have saved. Insert a graph from the Insert tab (assuming Excel 2007 or later, I'm looking at 2010). Right click on the graph space and Select Data, ensuring that you include the column title (e.g. date) as well as the data value. Voila. You can play around with a sliding week / month / year range if you like, once you have data...
... but why not just go to one of the many online resources that give you huge amounts of graphs and other data on every stock / share / fund / bond in the world - free! e.g. Hargreaves Lansdown - https://www.hl.co.uk/shares
SD
... but why not just go to one of the many online resources that give you huge amounts of graphs and other data on every stock / share / fund / bond in the world - free! e.g. Hargreaves Lansdown - https://www.hl.co.uk/shares
SD
Joined: Aug 2018
Posts: 96
Likes: 15
From: With hardship in an old Astra
Try pressing the "Scr Lk" (Scroll Lock) key on your keyboard...!
Last edited by FollowTheSupper; 8th April 2020 at 19:13. Reason: ambiguous term "button"
