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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks