Hi all, bit of a long shot, but...
Does anybody know if I can update a chart automatically as more data is populated, over time? In Excel 2016.
I have a set of data in various pivot tables - these Pivots update when I open the workbook each time using auto-refresh within the Options menu of the Pivots.
This Pivoted data then populates a normal table with various formulas in it, which lift data from the Pivots as and when it is updated.
Because I am looking at data with a time stamp (quarterly), I have pre-populated my normal table up until the end of 2020; so anything between today and the end of 2020 is showing as a zero figure (using IFERROR formula to get this) - this is so I can avoid having to add formulas and rows to my normal table each quarter.
I have charts created, using data in the normal table, which basically have data ranges covering data for dates that have passed.
If I want to update the chart in three months to cover another (yet to happen) quarter, then I will manually change the chart data range to cover this new quarter and the chart then updates.
IS there a way at all to make this happen automatically, so if the yet-to-happen quarter that is currently presenting with zero figures becomes populated with actual figures, it shows on my chart?
I don't want to have a chart with yet-to-happen quarters on it, hence the restricted and specific chart data range at the moment.
I have a lot of different charts you see, hence the question (if it was one, manual updates would be fine).
Thanks!
Does anybody know if I can update a chart automatically as more data is populated, over time? In Excel 2016.
I have a set of data in various pivot tables - these Pivots update when I open the workbook each time using auto-refresh within the Options menu of the Pivots.
This Pivoted data then populates a normal table with various formulas in it, which lift data from the Pivots as and when it is updated.
Because I am looking at data with a time stamp (quarterly), I have pre-populated my normal table up until the end of 2020; so anything between today and the end of 2020 is showing as a zero figure (using IFERROR formula to get this) - this is so I can avoid having to add formulas and rows to my normal table each quarter.
I have charts created, using data in the normal table, which basically have data ranges covering data for dates that have passed.
If I want to update the chart in three months to cover another (yet to happen) quarter, then I will manually change the chart data range to cover this new quarter and the chart then updates.
IS there a way at all to make this happen automatically, so if the yet-to-happen quarter that is currently presenting with zero figures becomes populated with actual figures, it shows on my chart?
I don't want to have a chart with yet-to-happen quarters on it, hence the restricted and specific chart data range at the moment.
I have a lot of different charts you see, hence the question (if it was one, manual updates would be fine).
Thanks!