Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .