creating a "squared" line chart !!!

[SSH]

I want to create a chart of average daily voltage, but using the line chart creates a sawtooth shape - see first chart below and in attached file.



"Smoothing" takes away the 'jaggedness' out of the line, but I really want the line 'squared'. Something like the upper outline of the following column chart - but without the fill (and without the outlines of the columns if I choose 'no fill').



Thanks for any help!
Cheers,
SSH

 

[Nebu]

Hi:

I am not sure what you are looking for. Does the attached do what you want.

Thanks

 

[SSH]

Nebu, thanks for your response, but no, not quite.
I want a "line chart" that is square !
Here's another shot along the lines you suggested using a flat-line as the "marker". So, each data point is flat, but where the lines connecting data points go from and to the edge of the flat-line marker. (In the figure below, the line connects from and to the midpoint of the marker. A square line chart is like a "square wave" but one where the amplitude ("peaks" and "troughs") varies (i.e., other than just 1 and -1).

 

[Hui]

Like this ?


See attached file:

 

[SSH]

Like this ?
View attachment 24989

See attached file:

Hui,

YES! Thanks heaps! I can see that the chart type you have used is a scatter plot with straight lines. But there seems to be something more because when I change to that chart type, I don't get the square wave! Is there something else I need to choose/do?

Cheers,
Stephen

 

[SSH]

Like this ?
View attachment 24989

See attached file:

Just seen that you have modified the data using an "OFFSET" command. Thanks, I'll work it out. Truly much appreciated.
Cheers, S.

 

[Hui]

Its a scatter chart
Yes it uses a second series to replicate each point, adding a day to each point so that each data point is plotted as 2 days (the actual date and the day after)