How to make a stairs graph in Excel?
 

I am trying to create from ordinary data graph whish looks like a digital
square shaped signal. Is there any function in Excel included which makes it
right away, instead of using repetition of each data cell twice?

Hi,

You will have to use some form of extra data to produce the step chart.
Here is some information on ways to create a step chart.
http://www.andypope.info/charts/stepchart.htm

Cheers
Andy

peter wrote:
I am trying to create from ordinary data graph whish looks like a digital
square shaped signal. Is there any function in Excel included which makes it
right away, instead of using repetition of each data cell twice?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Which of those graps is able to display values of data over each data entry?

€žAndy Pope" napÃ*sal (napÃ*sala):

Hi,

You will have to use some form of extra data to produce the step chart.
Here is some information on ways to create a step chart.
http://www.andypope.info/charts/stepchart.htm

Cheers
Andy

peter wrote:
I am trying to create from ordinary data graph whish looks like a digital
square shaped signal. Is there any function in Excel included which makes it
right away, instead of using repetition of each data cell twice?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi,

If you want to display data labels of the values then you will probably
need to add another data series, which means the 3d variations can not
be used.

Cheers
Andy

peter wrote:
Which of those graps is able to display values of data over each data entry?

€žAndy Pope" napÃ*sal (napÃ*sala):


Hi,

You will have to use some form of extra data to produce the step chart.
Here is some information on ways to create a step chart.
http://www.andypope.info/charts/stepchart.htm

Cheers
Andy

peter wrote:

I am trying to create from ordinary data graph whish looks like a digital
square shaped signal. Is there any function in Excel included which makes it
right away, instead of using repetition of each data cell twice?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info