Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have two series of data I wish to plot on the same graph: Series 1 has 10 data points, Series 2 has 15 data points.

I want to show both series on the same chart (presumably Scatter) with the points covering the same distance on the X Axis (i.e. Series 2 points are closer together and the final Series 1 and Series 2 displaying at the same point on the X Axis).

At the moment I am using a Scatter Chart.

EDIT here's my data, these are the two series:

  • 11.69 11.70
  • 11.87 11.70
  • 12.38 11.77
  • 11.89 11.96
  • 11.57 12.77
  • 11.67 13.16
  • 12.23 13.08
  • 12.21 13.28
  • 12.52 12.87
  • 12.24 12.82
  • 12.12 12.82
  • 12.21 12.89
  • 12.25
  • 12.49
  • 12.47
  • 12.78
share|improve this question

1 Answer 1

up vote 0 down vote accepted

If you're using a Scatter Chart, each series' points should be located based upon the X and Y coordinates of each point. As long as those are accurate, and the Chart's axis are both formatted to show the entire data range, it should automatically locate all points of both series properly. If you need a sample, post your data, and we can use it to generate one.

EDIT: Using your data, here's the chart I created. For the first series (16 values), use the values 1-16 for the X Axis. To create an evenly spaced second series, divide the 16 values into 12, then use those values for it's X axis. Your final result will look something like this:

Uneven series

If you need a different spacing/distribution for your second series, you'll need to plug different numbers into its X Axis.

share|improve this answer
    
heres my data, these are the two series:11.69 11.70 11.87 11.70 12.38 11.77 11.89 11.96 11.57 12.77 11.67 13.16 12.23 13.08 12.21 13.28 12.52 12.87 12.24 12.82 12.12 12.82 12.21 12.89 12.25 12.49 12.47 12.78 –  higfiny Oct 7 '13 at 19:22
    
Ok, I got what appears to be 28 values-how do they separate into two series? Also, assuming these are Y values, I don't see any X values. –  dav Oct 7 '13 at 19:25
    
edited question values are y values for both series. I don't have y values. –  higfiny Oct 7 '13 at 19:31
    
HERO! if i had upvotes to give i would –  higfiny Oct 7 '13 at 20:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.