Dynamic Range Chart ???
- From: "Yogalete" <al.rainey@xxxxxxxxx>
- Date: 27 Apr 2005 08:43:59 -0700
Hi,
After looking through the group's archives, I am trying to create a
chart that reflects a "rolling" date range. In this example it is for
91 days (13 weeks).
Here is what I have:
Col A Col b COL C Col D
Date disregard disgegard data to chart
I have hundreds of dates entered and col D's data is derived from a
formula.
Here are my named ranges
"IIIMonth": =OFFSET(Log!$D$2,COUNTA(Log!$D:$D)-91,0,91)
"Date": =OFFSET(Log!$A$2,COUNTA(Log!$A:$A)-91,0,91)
They seem to work, but the chart's data for col D does not match what
is in col d. The dates match, but not the data. For example, the value
in Cell A481 is 4/23/05. That is reflected in the chart. However, the
Data in D481 is 15.07, but the charted value is 11.97.
I am baffled. Hopefully this makes sense. Any help appreciated.
Al in Nebraska
.
- Follow-Ups:
- RE: Dynamic Range Chart ???
- From: John Mansfield
- RE: Dynamic Range Chart ???
- Prev by Date: I have 36 legend entries but only need the ones actualy graphed
- Next by Date: Re: Dynamic Range Chart ???
- Previous by thread: I have 36 legend entries but only need the ones actualy graphed
- Next by thread: Re: Dynamic Range Chart ???
- Index(es):
Relevant Pages
|
