[mso] Excel Charts

If I a sheet to calculate cumulative data on a bi-weekly basis for a
year and the formulas are in the sheet, if I define the entire year as
the range for the chart, then cumulative total for the time periods in
the future is the same as cumulative total for the current time period.
Is there a way to get Excel to not show the future periods in the chart
other than redefining the chart range every two weeks, or having to add
the formulas to the source data every two weeks?  It's impossible to get
a trend line with the future data in the chart, because it is just a
flat line from the current time period forward?

Thanks,

Christine McDonald, CPA
Technical Specialist
Western Regional Office
Information Technology Division (RSA-4)

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: