Scrolling through several graphs on one chart?

[Michael]

Hi everyone,

Suppose you have a 2D chart with multi-graphs inside; each represent
different solution for example.

Imagine, using VBA, you can create a Spin-button to scroll in-between
those solutions on the chart one-by-one. For example, solution 1 on
the chart will flash for 5 second, next solution 2 will flash and so
on...

On the other side, how can you select two or more solutions to flash
at the same time; for the sake of comparison?

Is this doable?

Regards,
Mike

 

[Debra Dalgleish]

It doesn't use a spin button, but you might get some ideas from Jon
Peltier's example on interactive charts:

http://www.peltiertech.com/Excel/Charts/ChartByControl.html