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 multiple blocks of time series data on an Excel sheet, with each block having its own set of dates. For example, I might have dates in column A, values in column B, and then dates in column D and values in column E. The values in B go with the dates in A, and the values in E go with the dates in D. The dates in A and D may not be the same. I would like to create a scatter chart with a time category axis that is the union of my two input date ranges in columns A and D.

If I select all the data and then go insert chart (in Excel 2010), Excel treats only column A as the X axis, and looks at D as just another set of values.

I can get Excel to do what I want by first just charting columns A and B, then selecting D and E and copy-pasting onto the chart. However, I would like to avoid this two-step procedure if possible.

share|improve this question

1 Answer 1

up vote 0 down vote accepted

If you select a data range in Excel and generate a chart, Excel only uses the data on the far left for its X values. If you have multiple series with distinct X values, you have to add each set of X-Y values in a separate operation.

share|improve this answer
    
But read "Intelligent Excel 2013 XY Charts" (peltiertech.com/WordPress/intelligent-excel-2013-xy-charts) for a description of how the newly released Excel 2013 allows you to plot alternating columns of data in an XY chart. –  Jon Peltier Feb 19 '13 at 12:39

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.