Dynamic Graphs, as columns are added daily

[chrono2483]

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:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date Range[/TD]
[TD]Oct 1[/TD]
[TD]Oct 2[/TD]
[TD]Oct 3[/TD]
[TD]Oct 4[/TD]
[TD]Oct 5[/TD]
[TD]Oct 6[/TD]
[TD]Oct 7[/TD]
[TD]Oct 8[/TD]
[TD]Oct 9[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Total Offered[/TD]
[TD]234[/TD]
[TD]897[/TD]
[TD]897[/TD]
[TD]678[/TD]
[TD]46[/TD]
[TD]876[/TD]
[TD]464[/TD]
[TD]876[/TD]
[TD]876[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Total Answer[/TD]
[TD]78[/TD]
[TD]769[/TD]
[TD]759[/TD]
[TD]647[/TD]
[TD]41[/TD]
[TD]657[/TD]
[TD]356[/TD]
[TD]789[/TD]
[TD]688[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Total Abandon[/TD]
[TD]100[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Abandon Rate[/TD]
[TD]5%[/TD]
[TD]5%[/TD]
[TD]5%[/TD]
[TD]5%[/TD]
[TD]5%[/TD]
[TD]5%[/TD]
[TD]5%[/TD]
[TD]5%[/TD]
[TD]5%[/TD]
[/TR]
</tbody>[/TABLE]

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!

 

[DanteAmor]

One option may be to select all cells from Oct 1 to Oct 31.
But, following your example, you hide the column cells from Oct 10 to Oct 31, so only the data from Oct 1 to 9 will be shown in the graph.

 

[Jon Peltier]

Turn your data range into a column (Ctrl+T). Make a plot from this data, using series in rows (switch rows and columns as needed). Since the entire table is used in the chart, adding columns will extend the series to include the added columns.