I have a large spreadsheet that has data in it that is entered weekly. I
would like for the chart to grab the most recent 26 weeks of data
automatically. Does anyone know of a formula that will do this?
I have a large spreadsheet that has data in it that is entered weekly. I
would like for the chart to grab the most recent 26 weeks of data
automatically. Does anyone know of a formula that will do this?
Logan:
If you haven't already, you may want to establish dynamic ranges for your
data set. This will allow you to automatically update your chart(s) as new
data is entered It will also allow you to plot the last number of days/weeks
that you want.
This post explains how to set up dynamic range names and plot user specified
number of days. It should get you started on dynamic range names and offset
formulas.
http://processtrends.com/pg_dynamic_charts.htm
[email protected]
"logan27371" <[email protected]> wrote in message
news:[email protected]...
>I have a large spreadsheet that has data in it that is entered weekly. I
> would like for the chart to grab the most recent 26 weeks of data
> automatically. Does anyone know of a formula that will do this?
Here is an example that plots the last 12 months, I'm sure you can change it
to the last 26 weeks:
http://peltiertech.com/Excel/Charts/DynamicLast12.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Kelly O'Day" <[email protected]> wrote in message
news:%[email protected]...
> Logan:
>
> If you haven't already, you may want to establish dynamic ranges for your
> data set. This will allow you to automatically update your chart(s) as new
> data is entered It will also allow you to plot the last number of
> days/weeks that you want.
>
> This post explains how to set up dynamic range names and plot user
> specified number of days. It should get you started on dynamic range names
> and offset formulas.
>
> http://processtrends.com/pg_dynamic_charts.htm
>
> [email protected]
>
>
> "logan27371" <[email protected]> wrote in message
> news:[email protected]...
>>I have a large spreadsheet that has data in it that is entered weekly. I
>> would like for the chart to grab the most recent 26 weeks of data
>> automatically. Does anyone know of a formula that will do this?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks