chrono2483
Board Regular
- Joined
- Aug 23, 2014
- Messages
- 164
- Office Version
- 2016
Hello,
I have searched online and in the forum for this answer. Everything I find only references is you have a table, or data within two columns, and you are adding additional rows of data.
My scenario is that I have my dates as my headers/labels, and my data name/header is in column A. As such, I paste a column of data each day. I have a line graph created to visualize the data, and I want it to automatically update each time I paste new data in (rather than having to extend the range to add the additional column).
Example:
<tbody>
</tbody>
Fictitious data, but illustrates my scenario. I have a graph that has the Date Range in the Horizontal axis, and the data series for Total Offered, Total Answer, Total Abandon and Abandon Rate in the Vertical axis.
Daily, I will paste in a new column for that respective date (Column J).
How do I get my graph to update automatically with his new date.
Note: I've tried defined names, as well as formatting as a table.
Would appreciate a point the right direction.
Thank you!
I have searched online and in the forum for this answer. Everything I find only references is you have a table, or data within two columns, and you are adding additional rows of data.
My scenario is that I have my dates as my headers/labels, and my data name/header is in column A. As such, I paste a column of data each day. I have a line graph created to visualize the data, and I want it to automatically update each time I paste new data in (rather than having to extend the range to add the additional column).
Example:
A | B | C | D | E | F | G | H | I | J | |
1 | Date Range | Oct 1 | Oct 2 | Oct 3 | Oct 4 | Oct 5 | Oct 6 | Oct 7 | Oct 8 | Oct 9 |
2 | Total Offered | 234 | 897 | 897 | 678 | 46 | 876 | 464 | 876 | 876 |
3 | Total Answer | 78 | 769 | 759 | 647 | 41 | 657 | 356 | 789 | 688 |
4 | Total Abandon | 100 | 10 | 10 | 5 | 5 | 100 | 100 | 10 | 10 |
5 | Abandon Rate | 5% | 5% | 5% | 5% | 5% | 5% | 5% | 5% | 5% |
<tbody>
</tbody>
Fictitious data, but illustrates my scenario. I have a graph that has the Date Range in the Horizontal axis, and the data series for Total Offered, Total Answer, Total Abandon and Abandon Rate in the Vertical axis.
Daily, I will paste in a new column for that respective date (Column J).
How do I get my graph to update automatically with his new date.
Note: I've tried defined names, as well as formatting as a table.
Would appreciate a point the right direction.
Thank you!