Scrolling through several graphs on one chart?
 

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

Scrolling through several graphs on one chart?
 

Hi Michael,

I did something like this once, but it relied on cell selection and not a
spin button; but spin button should work. As for displaying 2 solutions, I
don't think that can be done with the spin button unless you want to always
have 2 solutions displayed and they would have to be next to each other in
the list that the spin button is related to. You could do it pretty easily
using cell selection or listbox as the input.

HTH, Greg

"Michael" wrote in message
om...
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