# How to make a stairs graph in Excel?

1. ## 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?

2. ## Re: How to make a stairs graph in Excel?

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

3. ## Re: How to make a stairs graph in Excel?

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
>

4. ## Re: How to make a stairs graph in Excel?

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1