Forum Discussion
Excel Chart X-Axes
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:
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.