LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Create a Macro to give movement to a graphic.

Hi everyone,

I need to create a macro that allows me to make a graphic to move.

The graphic is about wave movement.

The problem is stated like this..

I have 2 columns. x and y.. The data they contain is all in negative
numbers ranging from -1,51 to -0,39 for column x and backwards for y.
The X column is the time column...
The macro idea is to make the graphic to change every 2 minutes in a
ranging time of 1-10 minutes.
In the bottom of the X column after all the negatives numbers, a cell
with the number 2 is shown.
And at the top of the Y column before all the negative numbers there
is another cell with the number 2. In top of that.

Here it is.. This is the data I guess I should use in order to create
the macro:

Tiempo ?
X 2
-1,51 -0,38
-1,50 -0,39
-1,49 -0,40
-1,48 -0,41
-1,47 -0,42
-1,46 -0,43
-1,45 -0,44
-1,44 -0,45
-1,43 -0,46
-1,41 -0,47
-1,41 -0,48
-1,40 -0,49
-1,39 -0,50
-1,38 -0,51
-1,37 -0,52
-1,36 -0,53
-1,35 -0,54
-1,34 -0,55
-1,33 -0,56
-1,32 -0,57
-1,31 -0,58
-1,30 -0,59
-1,29 -0,60
-1,28 -0,61
-1,27 -0,62
-1,26 -0,63
-1,25 -0,64
-1,24 -0,65
-1,23 -0,66
-1,22 -0,67
-1,21 -0,68
-1,20 -0,69
-1,19 -0,70
-1,18 -0,71
-1,17 -0,72
-1,16 -0,73
-1,15 -0,74
-1,14 -0,75
-1,13 -0,76
-1,12 -0,77
-1,11 -0,78
-1,10 -0,79
-1,09 -0,80
-1,08 -0,81
-1,07 -0,82
-1,06 -0,83
-1,05 -0,84
-1,04 -0,85
-1,03 -0,86
-1,02 -0,87
-1,01 -0,88
-1,00 -0,89
-0,99 -0,90
-0,98 -0,91
-0,97 -0,92
-0,96 -0,93
-0,95 -0,94
-0,94 -0,95
-0,93 -0,96
-0,92 -0,97
-0,91 -0,98
-0,90 -0,99
-0,89 -1,00
-0,88 -1,01
-0,87 -1,02
-0,86 -1,03
-0,85 -1,04
-0,84 -1,05
-0,83 -1,06
-0,82 -1,07
-0,81 -1,08
-0,80 -1,09
-0,79 -1,10
-0,78 -1,11
-0,77 -1,12
-0,76 -1,13
-0,75 -1,14
-0,74 -1,15
-0,73 -1,16
-0,72 -1,17
-0,71 -1,18
-0,70 -1,19
-0,69 -1,20
-0,68 -1,21
-0,67 -1,22
-0,66 -1,23
-0,65 -1,24
-0,64 -1,25
-0,63 -1,26
-0,62 -1,27
-0,61 -1,28
-0,60 -1,29
-0,59 -1,30
-0,58 -1,31
-0,57 -1,32
-0,56 -1,33
-0,55 -1,34
-0,54 -1,35
-0,53 -1,36
-0,52 -1,37
-0,51 -1,38
-0,50 -1,39
-0,49 -1,40
-0,48 -1,41
-0,47 -1,42
-0,46 -1,43
-0,45 -1,44
-0,44 -1,45
-0,43 -1,46
-0,42 -1,47
-0,41 -1,48
-0,40 -1,49
-0,39 -1,50
2 blank

The graphic is made in a lines graphic and it shows a single wave.

Would anyone help me to make that wave to move using a macro?

Help please.

Waiting for your prompt reply.

Kathy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I create pop up in excel to give direc. on filling out a ce lscharosch Excel Discussion (Misc queries) 2 July 26th 07 10:50 AM
Cursor movement in a macro Kanga Excel Discussion (Misc queries) 3 January 11th 07 01:10 AM
how do i set the enter key to give a horizontal movement excel tricks Excel Worksheet Functions 1 December 9th 05 09:28 PM
Trying to create formula to give range of stan.deviations of mean Roger Excel Discussion (Misc queries) 5 July 17th 05 06:58 PM
How do I create automatic cell movement when using excel babykates Excel Worksheet Functions 1 November 1st 04 01:22 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"