I am trying to create a graph that continually updates with the most current 14 days of data. I have three data series per graph tracking trends between data over a current 14 day period. Any suggestions as to how to set this up? Any advice is appreciated...
Depending on your data setup, some possible choices would be
Dynamic named ranges
Using the INDIRECT function
Pivot Table Charts
Try this:
Chart the last 12 months
Of course, you'll make an adjustment to show the last two weeks instead of the last year.
Jon Peltier
http://PeltierTech.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks