Excel – Chart which automatically creates data plot same time every day?
Is it possible to do this?
I’d like to create a line graph chart which updates automatically at the same time every day so I can monitor progress over time. It’s one total figure and ideally I’d like to show lines too for the subset data which this total is comprised of.
Thanks in advance if anyone can advise. 👍Posted 1 week ago
Sounds like it might be a job for PowerBI rather than Excel – though you’d need to pay if your source data is held on your own servers and/or you don’t want the report to be public.Posted 1 week ago
what’s the source?
are you populating cells manually?
dont you need to open and get into excel every time you update it or view it?
i know you can connect online services like google-sheets to online datasets and it will work away on the google servers without you needing to get involved, if your dataset is online or can get online on its own.
If you’re taking measurements yourself, you can use microprocessor like an arduino to feed directly into a google-sheets workbook, but that becomes a bit of an electronics project.Posted 1 week ago
or if you’re scraping values off an online source, you would need to get into the underlying data, but thats not my bag. i know my colleagues have used PowerBI to “harvest” datasets off websites before.
My organisation is years behind so we’re just getting Power BI but that’s only being given to the chosen few. I might have to scrap the idea as we can’t download external software either.
Thanks again.Posted 1 week ago
can you explain your requirements more clearly or in more detail?Posted 1 week ago
will there be a human available to click a macro button?
If so, you just need a macro to resize the chart with the latest data.Posted 1 week ago
You don’t even need a human, name the macro auto_open (need to check that it’s a while since I’ve done this). Then set a scheduled task on a PC to open the workbook at the set time. It’ll run automatically. You can even close and save it at the end from the macro.Posted 1 week ago
Could you use a timer within VBA? Given how awful excel is I expect this means that excel, and probably the PC, would be dedicated to this single task. Might be easier just to press a macro button.
edit. Though @stumpyjon ‘s response may be what you need.Posted 1 week ago
A macro can run from the open (workbook) event. This could refresh a query – data source could be pretty much anything.Posted 1 week ago
You must be logged in to reply to this topic.