Plotting Voltage Changes"

**raedbenz** · 08-06-2008, 12:59 PM

hi,
i have this set of data (d.jpg). each cell is 2ms.
I want to compute how much is spent on each set (shown as one color) until the sate changes. In other word, the values are voltages, so i want to know how often the voltage toggles. then plot the toggling instances.
thanks

**Leith Ross** · 08-06-2008, 01:26 PM

Hello raedbenz,

So that you can receive a fast answer to your post, please change your title to something more descriptive like, "Plotting Voltage Changes". If you haven't already done so, please take some time to review the forum's rules on posting. You can click on this link Forum Rules

Sincerely,
Leith Ross

**ravishankar** · 08-07-2008, 01:54 AM

Hi
paste your data in col A & B and run the macro.
Ravi

**raedbenz** · 08-07-2008, 04:15 AM

Originally Posted by ravishankar

Hi
paste your data in col A & B and run the macro.
Ravi

Hi Ravi,,
thanx for the reply, i get warning about security level, when i click the macro.
here it is :untitled.JPG

thnaks

**Phil_V** · 08-07-2008, 04:21 AM

Yes... do as the message says.

To change the macro security level so that it asks you whether to run macros or not, (in Excel 2003) do the following:

Tools -> Options...
Select the Security tab
Click [Macro Security...]
Set the level to 'Medium'
Click [Ok] on each open form
Close and reopen the workbook that contains the macro

This is a 'one-time' requirement and the setting is stored with Excel, not with the document.

**raedbenz** · 08-08-2008, 07:31 PM

Originally Posted by ravishankar

Hi
paste your data in col A & B and run the macro.
Ravi

hi,,
i really appreciate your effort.
but i need to know the following, in case i need to change the time interval (instead of 2m to 1 ms or 100us).
I found inside the macro code these two lines:

Cells(e, 4) = Cells(e, 4) + 2

i tried to do it like that
Cells(e, 4) = Cells(e, 4) + 1
is that ok for 1 ms ??
one last thing, how can i change the graph type?
Thanks

Raed

**ravishankar** · 08-09-2008, 11:54 AM

HI
you can use 1 ms or fractions there off (0.5 or 0.025(for 25 micro seconds))
you can record the macro for the chart of your choice and replace the codes.
Ravi

**raedbenz** · 08-09-2008, 12:41 PM

hi,,
one more thing, how do u compute the number of cells is it by computing the cells that have the same color or what?
bcoz the values i have are in 2500 cells and no way to color each voltage level.
thanks