+ Reply to Thread
Results 1 to 2 of 2

Lock Chart Display to last 14 days (or data points)

  1. #1
    toilinthedark
    Guest

    Lock Chart Display to last 14 days (or data points)

    I have some tables that are updated daily with a data point. I would
    like the chart to just display the most recent 14 days without having
    to manually change the source data range each time a new point is
    added.
    Any ideas?
    Thanks


  2. #2
    Jon Peltier
    Guest

    Re: Lock Chart Display to last 14 days (or data points)

    This page shows a chart of the most recent 12 months. Change a couple
    constants, and it'll do your last 14 days:

    http://peltiertech.com/Excel/Charts/DynamicLast12.html

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______


    toilinthedark wrote:
    > I have some tables that are updated daily with a data point. I would
    > like the chart to just display the most recent 14 days without having
    > to manually change the source data range each time a new point is
    > added.
    > Any ideas?
    > Thanks
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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