AHH! I am trying to do exactly this, EXCEPT I'm inserting a new column at the beginning as new data comes out every day. So, in your example I'd be adding a today's date in column "AD" ahead of existing data in "AD" and every time i do, the chart shifts the plotted data 1 column right and only includes "AE" and onward (It does correctly compensate and shift the end to now "AP" as opposed to "AO") How do I get it to ALWAYS stay plotting from "AD" to the end? (I want the compensation to remain shifting the end of the data 1 column right still)
I'd recommend having the chart look at data from AD. But keep AD blank, then insert column before AE each time (your latest day). Normally, I set stuff up so the new data is added as a new column on the right, not the left, to match a logical timeline. But let me know if you find a solution!
Hi Thanks for the video. Say you have a chart for the USA and a Chart for the UK separately. What would you do to have Excel update those charts when you add a new column? This differs from what you described in the video because you have to update every chart separately now. Thanks.
I would probably go for having my measures feeding my UK chart on one row, then the USA on an equivalent row underneath lined up, then I only need to inset a column once (rather than have for example on separate sheets). Hope that helps!
Thank you. Every reference I've come across dealing with this seemed to focus on rows, where I have all my moving data in columns.
Awesome, glad it helped!
AHH! I am trying to do exactly this, EXCEPT I'm inserting a new column at the beginning as new data comes out every day. So, in your example I'd be adding a today's date in column "AD" ahead of existing data in "AD" and every time i do, the chart shifts the plotted data 1 column right and only includes "AE" and onward (It does correctly compensate and shift the end to now "AP" as opposed to "AO") How do I get it to ALWAYS stay plotting from "AD" to the end? (I want the compensation to remain shifting the end of the data 1 column right still)
I'd recommend having the chart look at data from AD. But keep AD blank, then insert column before AE each time (your latest day). Normally, I set stuff up so the new data is added as a new column on the right, not the left, to match a logical timeline. But let me know if you find a solution!
Hi
Thanks for the video. Say you have a chart for the USA and a Chart for the UK separately. What would you do to have Excel update those charts when you add a new column? This differs from what you described in the video because you have to update every chart separately now.
Thanks.
I would probably go for having my measures feeding my UK chart on one row, then the USA on an equivalent row underneath lined up, then I only need to inset a column once (rather than have for example on separate sheets). Hope that helps!