# Thread: Graphing a moving data series (XP +)

1. ## Graphing a moving data series (XP +)

I have a graph that shows a data series from "Date A" to "Date B" taken from columns. I would like to extend my data input in the columns such that the data continues beyond "Date B". However, I would like the graph to show the data series for X number of days with current date in the center. In other words, the graph will remain static and the data will move within the graph as the dates progress.

Is this even possible? A search of the Excel forum has not yielded results.

2. ## Re: Graphing a moving data series (XP +)

Can you explain that again, but more slowly? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
Perhaps you could attach a sample workbook to illustrate what you mean?

3. ## Re: Graphing a moving data series (XP +)

I think you want to use a named formula to create a "Dynamic Chart". Jon Peltier has a link to some examples of Dynamic Charts which should be adaptable

If you need additional help, could you provide more details and maybe an example set of data?

Steve

4. ## Re: Graphing a moving data series (XP +)

Okay Hans.. slower. This is related to Post: 652,678 where I will have three columns.. A=Date; B=Weight; C=Minutes. I want to continue filling those columns for the entire year but I only want the graph to show the current date (in the center) with the previous two weeks to the left and I will have a trend line projecting to the right edge of the graph. As the year progresses, I would like the graph to always show the date range of [today-14days : today+14days] without me having to go into the graph and change the data series start/stop points. I will try to construct an example of what I mean but I hope this makes it more clear.

5. ## Re: Graphing a moving data series (XP +)

The techniques used in the one from Erlandsen Data Consulting that displays the last 12 months should be adaptable...

Steve

6. ## Re: Graphing a moving data series (XP +)

Thanks, I will take a look at those.

I barely got into them and found that the one from Andy Wiggins is probably adaptable to my needs. Very clever.. all done without VBA.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•