Excel Scatter Plot Date Axis Not Working. Right-click on the X-Axis change the Axis type to Date axis to be sure excel sees the X-values as dates. I hope i helped you with this.
Mar 10 2020 -Right click the Date on your Scatter Plot -click Format Axis -click Number on the left Pane -Change the Category Type and Format Code of Date. More Horizontal Axes Options Under Axis. Then set the data colors as white colorhighlighted in red line and set the shapes of chart you can set the marker shapehighlighted in blue line and the marker color of different legend by choosing the different valuehighlighted in yellow.
In Excel 2007 click on the chart - Go to the layout menu contextual menu on clicking on the chart choose the option Axes-Primary Horizontal Axes-.
Then set the data colors as white colorhighlighted in red line and set the shapes of chart you can set the marker shapehighlighted in blue line and the marker color of different legend by choosing the different valuehighlighted in yellow. Category and not date. Convert them to be actual Excel dates and everything should work fine. Typically the independent variable is on the x-axis and the dependent variable on the y-axis.
