- last edited on
I have some graphs in Excel which use data from a table in a separate tab, my history tab. Every day I update this history tab by copying a bunch a data through a macro button to this history tab. So basically the list with data grows by one line every day.
I would like my graphs to use the updated table with data automatically, but currently it skips all the newly added data.
Can anyone help me out with this? What do I do to keep the graph up to date automatically?
10-23-2017 08:01 AMSolution
10-23-2017 01:54 PM
That works indeed. Thanks very much!
Now one more problem with the graph: it starts with the most recent line of data on the left (which is at the top of the table). But I would like to have that on the right.
So I would like to have the oldest data in my graph on the left on the x-axis and the most recent data on the right of this axis.
How do I get that done?