Hi NScarritt:

Yes, this is possible.

The best approach will be to use dynamic range names. You can look this up on the internet. Here is one example:

http://support.microsoft.com/kb/183446

Another approach would be to force the irrelevant data to show as #N/A. Excel ignores this data for chart purposes. This is especially helpful when you don't want a line chart to dive to the X axis at the bottom.


Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If we have been of assistance, please let us know. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".