special effects in charts

[joseluis]

Hi!
I have a chart, which represents a complicated equation,
and I've combined it with a dot that is the solution of
another equation. The dot changes its position when I
change the input data, but de curve stays always the same,
so it´s possible to determine some important
characteristics of the problem just by watching the chart
and the position of the dot.
The problem is: how can I make this point to flash every X
seconds, or to change its colour every X seconds? Is it
possible? And if it is, how? Thanks for helping.
joseluis

 

[Brad Reid]

Someone will do this much more eloquently than I, but could should work:

A1 is your Dot value
B1 is =Second(Now())
C1 is =If(B1>30,A1,"")
D1 is =If(B1<=30,A1,"")

B1 pulls the seconds from Now() which gives hh:mm:ss
C1 and D1, based on your "If logic" will blink back and forth depending on
where the seconds are at any given point in time.

When you graph your dot, do a separate series for C1 and D1, and only one or
the other will show up at a given point in time. Just format the two
separate, but equally valued representations of the same dot value in
different colors so that it blinks a different color, or a different object
every 30 seconds.

Just follow along this form of logic to derive other possible timing
patterns. Anyway, it uses formulas with no VB. Cheers! Brad


Hi!
I have a chart, which represents a complicated equation,
and I've combined it with a dot that is the solution of
another equation. The dot changes its position when I
change the input data, but de curve stays always the same,
so it´s possible to determine some important
characteristics of the problem just by watching the chart
and the position of the dot.
The problem is: how can I make this point to flash every X
seconds, or to change its colour every X seconds? Is it
possible? And if it is, how? Thanks for helping.
joseluis

 

[Brad Reid]

You know, make that NA() instead of "" for C1 and D1 like: C1 is
=IF(B1>30,A1,NA())

It'll make the chart work better. Brad

 

[Tushar Mehta]

You would have to use some kind of VBA program to accomplish this. For
an example on how to make something similar to Brad's suggestion work
see http://www.tmehta.com/tmxl/dbfind_byid.asp?id=14

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions