Excel Scatter Plot X Axis Labels Wrong. There are two data series for the Y values. One way to spot this is if the numbers are not on the right side of the cell when no formatting has been applied to the cell.
Actual temperatures and and. Select the source data. Select the series you want to add a secondary axis for.
I am making a graph of data collected during a time period where the x-axis is the date and the y-axis is the value collected.
It will open the Explore sidebar panel. Jun 16 2012 Format the chart X axis to not show any labels or tick marks. I think that all of the values are plotting but the x-axis values are. Right-click the X-axis in the chart you want to change.
