Data Missing when Plotting 2 Axes with Different x-axis Values

[mnott]

Hi there,
I'm currently trying to plot two different data sets on the same line graph. The x-axis is time for both, however, the time is spaced at different intervals for each. (i.e. one records a point every 15 seconds, and the other records a point every 20 sec).


My attempt at combining them has been this:


1) Put all times in one column, starting with the first set of times 0-x by 15, followed by the next set 0-y by 20.
2) Put data set 1 in the column to the right of the time column.
3) Put data set 2 in the same column directly below.


When I do this and try to plot the data on a line graph, I get all of the data points for the top set of data, but the bottom set of data gets cut off towards the end.


How do I fix this?


Thanks!

 

[Arjan77]

It's not completely clear what you are trying to achieve, do you want each point on the x-axis represent two values (multiples of 15 and 20) or do you want the x axis to be a continuous time line with the corresponding y-values?

 

[mnott]

It's not completely clear what you are trying to achieve, do you want each point on the x-axis represent two values (multiples of 15 and 20) or do you want the x axis to be a continuous time line with the corresponding y-values?

I HAVE 2 sets of y values both dependent upon the X-var: time in seconds. I WANT to plot both sets of y-values on the same graph as different series to compare the two. HOWEVER, the x-values corresponding to the two sets of y-values are at different intervals...FOR example:

In set A, the first three coordinates are (0, y1), (15, y2), and (30, y3),
In set B, the first three coordinates are (0, y4), (20, y5), and (40, y6)

How do I plot both on the same line graph?? I'm running into issues combining them.

 

[Jon Peltier]

Use an XY Scatter chart, not a line chart.

 

[mnott]

Use an XY Scatter chart, not a line chart.

Why would this not work on a line chart?

 

[Jon Peltier]

If you're plotting numeric X values, you should use an XY chart, because a line chart doesn't know how to treat the X values numerically.

Here's the data you just described, put into three columns as you described earlier:

But in an XY chart, you don't need to mess up your data. Here is a screenshot showing the data in separate regions.

Select the blue shaded range, and insert an XY Scatter chart (top chart).

Copy the orange shaded range, select the chart, then use Paste Special from the Home tab, and use the settings in the Paste Special dialog shown below left.

The resulting chart is shown below right.