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