Offset Function Chart from selected columns

Hi,

I have a table of data with the dates in column A and then various different types of data in the following columns, and I add new data to the bottom of the table each week. I have several charts that are linked to this table and and display what has happened historically as line graphs. Rather than always manually editing the data range for each graph each week I was going to use the OFFSET function in a range and macro to automatically add the new data to my graphs each week.

The problem is that as the date data is in the first column I am unable to use ranges for my data names, as I need to skip some columns for certain graphs. Example:

Date Column B Column C Column D
01/01/2008 102 139 141
02/01/2008 111 174 162
03/01/2008 106 175 157
04/01/2008 158 166 172
05/01/2008 162 138 166

So I want one line graph with the Dates and data from B & C, and another with the Dates and C & D data.

Anyone have any ideas how I can use the one table and have several easily updatable graphs (e.g. via click macros) linked to it?

Many thanks in advance,

Stebo148

Thanks Andy,

The radio button idea might work. Is there a way to rewrite the code so that I can display multiple lines at the same time for trend comparisons? (e.g. use multiple check boxes)

Ideally I would still prefer to be able to set up dynamic named ranges that uses only specified columns from the table, i.e. thcolumns that aren't necessarily next to one another, so that I can have all the graphs displaying the right data already when people open up the sheet.

Excellent site! After reading most of the the guides one near the bottom had what I'm looking for. TA Andy!