How do you make a chart with right angles only?
To make a dynamic chart you can use insert name define...
eg: X_Values: =Sheet1!$A$1:$A$5 ; Y_Values: =Sheet1!$B$1:$B$5
StepX: =X_Values+{0,0}
StepY: =LOOKUP(ROW(Y_Values)-{1,0},ROW(Y_Values),Y_Values)
Now set the chart formula to: =SERIES(,Sheet1!StepX,Sheet1!StepY,1)
"Theresa9599" wrote in message
...
I have a set of data with times and a bunch of 0's and 1's. For example,
at
1:30 p.m., I have a 0....2:00 p.m., I have a 1...2:30 p.m. I have a 0,
etc.
I have my 0's and 1's set up on the vertical axis and the times along the
horizontal axis.
I want my chart to show horizontal and vertical lines ONLY. IE: I want
a
point at "0" at 1:30 p.m., then I want a horizontal line over to 2:00
p.m.,
and then I want a line going straight up to "1", and then I want a
horizontal
line over to 2:30 p.m., and then I want a vertical line straight down to
"0",
etc.
Currently, I am getting diagonal lines connecting the points.
Is what I am trying to achieve possible, and if so, how?
Thank you!
|