Scrolling through several graphs on one chart?

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two-tone color column chart 2
Excel VBA - Graph/Chart on Userform 4
Excel chart, set a vertical baseline on a certain date 0
Change font in multiple charts and graphs 0
Word On a bar chart I want to have just one horizontal line, crossing the y axis at a value I determine. 1
Multiple Chart function (Access 2007)-builds graphs on one page on 0
How to change chart properties. 2
Plotting duration of activity on a graph 1

Back
Top