Jack Thompson
New Member
- Joined
- Dec 5, 2016
- Messages
- 1
Hi
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.
<tbody>
</tbody>
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.
| 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 |
| | | | | | | |
<tbody>
</tbody>