LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Yogalete
 
Posts: n/a
Default Dynamic Range Chart ???

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charting data points and show a target range on the same chart. Minireefkeeper Charts and Charting in Excel 6 February 18th 06 06:50 PM
how to change range for dynamic chart in excel 2000 with button? ivan Charts and Charting in Excel 2 April 24th 05 04:10 AM
Dynamic charting problems (events) [email protected] Charts and Charting in Excel 4 January 27th 05 09:32 PM
dynamic range for excel chart bobf Excel Discussion (Misc queries) 1 January 26th 05 11:07 AM
named range refers to: in a chart Spencer Hutton Excel Discussion (Misc queries) 1 December 14th 04 10:15 PM


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"