Two tables, one chart

[Ove]

Maybe an interesting challenge:
I have two different tables, one that goes over 3 columns and 6 rows,
the other is over 7 columns and 3 rows.
What I would like to do is having one chart to present the tables and
switch using a form spinner button. I know how to do it if the tables
are the same number of columns and rows, but not when they are
different sizes.

Any one?

Thanks in advance.

Ove Malde

 

[K Dales]

-----Original Message-----
Maybe an interesting challenge:
I have two different tables, one that goes over 3 columns and 6 rows,
the other is over 7 columns and 3 rows.
What I would like to do is having one chart to present the tables and
switch using a form spinner button. I know how to do it if the tables
are the same number of columns and rows, but not when they are
different sizes.

Any one?

Thanks in advance.

Ove Malde
.

You need to use the ChartObjects and SeriesCollection
objects to programatically specify the data ranges in the
chart - too complicated to summarize here! Look at the
MSDN Library under ChartObjects and SeriesCollection, and
also search the knowledge base. It is also instructive to
record a macro where you specify the source data for the
chart and then look at the code in VBA to see how Excel
references the data series.

Hope this little hint at least helps you get started...