Thanks for both of your suggestions I will take a look at them. I will write
back if I get stuck.

Once again thanks

"Fysh" wrote:

Hello, I have used Excel in the past, but nothing to this extreme. I have a
worksheet with about 15-20 columns. At the top of these columns I created a
toggle button for each column. One of the columns consist of trimesters,
another is in years others have data. What I would like to do is create a
chart on my worksheet which would be populated using the trimesters, years,
and the data for that particular column. Is this possible or do I have to
create a chart for each column? I was wonder maybe I need to run some code
behind the button to popluate another column with the particular data from
the column I need the data from. Another problem I might run into is that
the data cloumns can grow for each trimester and year.

Hopefully what I am suggesting is possible. Can someone provide any input
on this?

Thanks,