Forum Discussion
Excel Chart X-Axes
I want to chart a few different data sets on one graph. The data sets don't have identical X-axes (for time). They overlap, but the time series have different start and end points. Is there any way to configure an Excel point graph to accmmodate different time series data sets which don't have identical time (X-axis) bounds?
yes, you want to use the Scatter chart type:
so you can click the 1st pair and create the scatter chart. Then highlight the second set and hit 'copy' and then click on the graph and go up to the 'paste' drop down and select 'paste special' then in the pop-up option you select 'Categories (X Values in First Column)':
If you already have a scatter chart you can change the X-values a few different ways. One easy way is to click on that series in the chart (make sure to click 1 time to select the whole series and don't select a single point). Then in the formula bar you can change the reference for the X-values. The references are in the format =SERIES( [series name]. [series x-values], [series y-values], [series index] ) so simply change the second section of the formula to change the x-value reference range:
2 Replies
Use an XY Scatter chart and add each series through Select Data > Add. Give every series its own X range and Y range; the ranges do not need the same start date, end date, or number of points. Excel will place them on the same date axis, and you can set fixed minimum and maximum bounds only if needed.
yes, you want to use the Scatter chart type:
so you can click the 1st pair and create the scatter chart. Then highlight the second set and hit 'copy' and then click on the graph and go up to the 'paste' drop down and select 'paste special' then in the pop-up option you select 'Categories (X Values in First Column)':
If you already have a scatter chart you can change the X-values a few different ways. One easy way is to click on that series in the chart (make sure to click 1 time to select the whole series and don't select a single point). Then in the formula bar you can change the reference for the X-values. The references are in the format =SERIES( [series name]. [series x-values], [series y-values], [series index] ) so simply change the second section of the formula to change the x-value reference range:
