Formula for a range that takes x values from two columns in a particular order?

I don't think a chart is going to be able to easily do this by itself.

Would you be allowed to make a copy of the data arranged so the chart can do this? The chart will do this if you can arrange the data (or a copy of the data) in the spreadsheet so that it is arranged

Please Login or Register  to view this content.

then use this pair of columns as the source data for the chart. If I understand what you want, it is going to be very difficult using the data exactly as shown in your picture, but should be very easy if you can rearrange (a copy) of the data.

I'd like to do this with out having to manually copy and paste. I'm not sure the best way to go about it.

A lookup function can be useful for this as well as other tools. Are the x values always 1, 2, 3, 4, ...? Are they always divided odd/even like in your example (odd x always in D and even x always in I)? Any other patterns or considerations that need to be considered when programming a more automated solution?

Assuming x is always count numbers and always split even/odd like in your picture, something like

Please Login or Register  to view this content.

choose a pair of columns that work for you or even put this copy of the data on a different tab, and do something like I describe above. As noted, I'm assuming x will always be 1,2,3,4,5... and they are always split even/odd as shown above. If my assumptions are off, then adapt the formulas accordingly.