LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default graph range varying depending on dates

I am new to programming. I need to create a graph with a data source range
which will vary depending on the date. For example,

I have a table which contains all the weeks of the year and need to graph on
a rolling 13 week period. i.e. If we are in week 14 I need the graph to show
the data for weeks 2-14, if we are in week 15 I need the graph to show the
data for weeks 3-15. I would like the user to be able to specify the current
week. The graph would be preformatted and will just need to be updated. (I am
using Excel 2003)

Any ideas?

Thanks
Susie
 
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
Automatically vary range in graph depending on #rows data entered? dalek Charts and Charting in Excel 1 July 2nd 08 04:45 AM
bar graph with varying Y scales [email protected] Charts and Charting in Excel 3 September 14th 06 11:14 PM
How do I add totals from a range of dates depending on the month? confused Excel Worksheet Functions 3 September 12th 06 02:53 AM
varying colors on a graph drumerboy Excel Programming 9 January 14th 06 05:07 PM
displaying varying toolbars depending on workbook Rich[_13_] Excel Programming 0 July 30th 03 11:26 PM


All times are GMT +1. The time now is 10:04 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"