Paul Smith
New Member
Hi there
I would like the chart to update automatically when adding additional data.
Every month (July, August, September, below), a report is issued with estimates of future quarterly and annual production (E.g. 4Q16, 2016 etc)
To plot the data I would first highlight a column and add a line chart, I would then subsequently right click the chart, select data and add each desired column individually as a data series (and edit dates accordingly).
Estimates for each year end e.g. 2016 and 2017 are represented as one data series and the same is done for the quarterly data.
Year-end data series, and Quarterly data series cannot be plotted on the same charts and are plotted on separate charts (2016 and 2017 estimates are on the same chart)
The data has been set up per the table below and I am not allowed to rearrange it.
Manually adding this data is time consuming and as there is a lot of this data, errors are likely to occur, I would thus like to use a function that will auto update the chart as I enter data.
Thus when I add the data for October November and December, I would not like to manually update the charts as I have been currently doing. Please refer to the following file for an example of the charts that have been created.
4Q16
2016
1Q17
2Q17
3Q17
4Q17
2017
September 2016
96.9
96.1
96.5
96.8
98
98
97.3
August 2016
97
96.3
96.7
97
98.2
98.1
97.5
July 2016
96.9
96.1
96.6
96.9
98.1
98.1
97.4
I would like the chart to update automatically when adding additional data.
Every month (July, August, September, below), a report is issued with estimates of future quarterly and annual production (E.g. 4Q16, 2016 etc)
To plot the data I would first highlight a column and add a line chart, I would then subsequently right click the chart, select data and add each desired column individually as a data series (and edit dates accordingly).
Estimates for each year end e.g. 2016 and 2017 are represented as one data series and the same is done for the quarterly data.
Year-end data series, and Quarterly data series cannot be plotted on the same charts and are plotted on separate charts (2016 and 2017 estimates are on the same chart)
The data has been set up per the table below and I am not allowed to rearrange it.
Manually adding this data is time consuming and as there is a lot of this data, errors are likely to occur, I would thus like to use a function that will auto update the chart as I enter data.
Thus when I add the data for October November and December, I would not like to manually update the charts as I have been currently doing. Please refer to the following file for an example of the charts that have been created.
4Q16
2016
1Q17
2Q17
3Q17
4Q17
2017
September 2016
96.9
96.1
96.5
96.8
98
98
97.3
August 2016
97
96.3
96.7
97
98.2
98.1
97.5
July 2016
96.9
96.1
96.6
96.9
98.1
98.1
97.4
