Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I freeze a chart from scrolling | Charts and Charting in Excel | |||
Scrolling Along Chart | Excel Discussion (Misc queries) | |||
Chart Zooming and scrolling | Charts and Charting in Excel | |||
Scrolling through chart | Charts and Charting in Excel | |||
Scrolling chart | Excel Discussion (Misc queries) |