Home |
Search |
Today's Posts |
#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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3 d graph using depth in Ft., a N-S direction in . | Charts and Charting in Excel | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
finding the area under the curve in a graph in excel | Excel Discussion (Misc queries) | |||
is there a way to make an Excel file smaller than 296K? | Excel Discussion (Misc queries) | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions |