Excel Scatter Plot With Month Labels. Apr 22 2019 How to create a scatter plot in Excel. The X axis shows dates which are interpolated from the data.
Scatter Charts Docs Editors Help from support.google.com
Do not select any other columns to avoid confusing Excel. By default Excel shows one numeric value for the label y value in our case. Then select each data series and add data labels.
Id like the axis to have markers at 1-Jun 1-Jul 1-Aug etc but I have not found a way to do this.
Assuming the current Y values for the other series are the numbers 1 to 6 for even positioning you can use a range with Y values 1 to 6 and X values of zero and add that data range as a new series to. However Excel added data to the x-axis that isnt there at all - starting from 0 and ending on 4 instead of 15 to 35 as the x-data clearly contains. Select cell range B3C11. By default Excel shows one numeric value for the label y value in our case.
