<div>
yes it can also be done via vba and for this we need you to upload a sample file so to see where is your range and how to go about doing it.<br />
Rgds/gowflow
</div>


yes it can also be done via vba and for this we need you to upload a sample file so to see where is your range and how to go about doing it.
Rgds/gowflow

<div>
<div class="content wysiwyg-content">
I have a worksheet that contains a range, that range is named XYZ. &nbsp;This range covers five days of data which in turn produces a chart line chart with five lines to include the data within those days.<br />
<br />
Without having to manually adjust the range to include the newest days entry made each day, how can i make this so I can enter in the recent days data and it cover that day and the four prior days data automatically without me having to go in and manually adjust that table to cover those five days? &nbsp;<br />
<br />
Is there a way to tell excel to do this automatically so that it captures the new day and the four previous days so that the table grows dynamically without it having to be readjusted?
</div>
</div>


I have a worksheet that contains a range, that range is named XYZ.  This range covers five days of data which in turn produces a chart line chart with five lines to include the data within those days.

Without having to manually adjust the range to include the newest days entry made each day, how can i make this so I can enter in the recent days data and it cover that day and the four prior days data automatically without me having to go in and manually adjust that table to cover those five days?  

Is there a way to tell excel to do this automatically so that it captures the new day and the four previous days so that the table grows dynamically without it having to be readjusted?

Excel 2010:  Table Range Question

A miscellany is defined as a "collection of various pieces of writing by different authors", but it has come to mean something "Of items gathered or considered together of various types or from different sources" or "a collection or group composed of members or elements of different kinds". The word "miscellaneous" comes from the Latin word "miscere", meaning "to mix." You might have heard the expression "a mixed bag," which applies when you don't quite know what you're going to get. More commonly, a miscellaneous group is made up of an odd group of things that don't fit anywhere else.

Miscellaneous

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.