Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
Dynamic charting problems (events) | Charts and Charting in Excel | |||
dynamic range for excel chart | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) |