Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #4
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #6
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •