I have an XY scatter chart - X axis is a date with some dates missing, Y is a number for each date, Y is 0 for missing dates in X:
As you can see from the picture, the X axis is labeled with the ordinal number of the cell in the X-column, and I want it to be the date. There used to be an option to edit the data series to use the X values as data in a XY scatter chart - I can’t find it. In the Menus or by clicking on the data series. Has this option moved or gone away?
Possibly relevant: The X and Y data is in a pivot table.