Stretch data series in chart

[Roger W. Fischer]

Hello,

is there a way to stretch some but not all data series in a chart in Excel?

I measure the response times for a set of operation types over a fixed time
period. However, each operation type has a different frequency.

So I have (for example) 20 charting points per hour for operation a, 30
charting points for operation b, and 60 charting points for operation c. The
data points have timestamps, but they are not synchronized.

Now I want to chart these results so that the curves match up. The first
point of each data series is at the start of the chart's X-axis, and the
last of data point of each data series is at the end of the X-axis.

How would I do this?

Roger

 

[Andy Pope]

Hi Roger,

Sounds like you need to use the xy-scatter chart (xaxis values) rather
than the line (xaxis category).
Right click chart and chose chart type. Change to xyscatter.

Cheers
Andy