How to make a stairs graph in Excel?

[peter]

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]

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

[peter]

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]

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