If using straight lines between data points, the graph will connect coordinate (4, 0) to (5, 1).

In your example, I would like to show a vertical line from (5, 0) to (5, 1).

I can modify the data by adding a data point (4.99, 0), but I would like to avoid this.  (Yes, I could duplicate the data and create a macro to add extra data points. But if the capability already exists I would like to try it.)

Thanks for your response,

Doug


-----Original Message-----
From: Eisermann, Phil [Ridg/CO] [mailto:peiserma@RIDGID.COM]
Sent: Friday, January 16, 2004 12:28 PM
To: PICLIST@MITVMA.MIT.EDU
Subject: Re: [EE]: MS Excel 2002. How to graph a step function or square wav e?

pic microcontroller discussion list wrote:
> What kind of graph shows a step, square wave, or 'postage meter'
> function?
>

The generic name in Excel would be XY (X versus Y) or Scatter graph.
It is very straightforward and similar to doing it by hand in
high school math class.

Since you are asking this question, I will assume you need to know
how to set this up, or else you wouldn't have had to ask the
question in the first place! Unless I severly misunderstood the
question, and then I guess I look pretty dumb and wasted a lot
of time :)

example:
for a step function that is 0 Volts (or whatever units you are using)
for t<5 seconds (or whatever units/base) and is 5Volts  t=>5 sec,
you would enter data in two columns. first column is time, second is
volts. so for example:

TIME VOLTS
0    0
1    0
2    0
3    0
4    0
5    1
6    1
7    1
8    1
9    1
10   1

then highlight the two columns and click the chart wizard.

-Phil Eisermann

--
http://www.piclist.com hint: To leave the PICList
mailto:piclist-unsubscribe-request@mitvma.mit.edu

--
http://www.piclist.com hint: To leave the PICList
mailto:piclist-unsubscribe-request@mitvma.mit.edu