I am trying to add additional vertical axis labels to a logarithmic chart (Excel365).
My data goes from 6900 to 7600. I would like to add 6900, 7000, 7100, 7200 etc as additional axis labels.
The issue is that I have the horizontal axis set as a text axis, and not a date axis, as I have two data points per each date which must be depicted separately (not on the same label/tick mark).
As a result, creating a dummy series of new vertical axis labels with the corresponding y-value set to 0-minimum will not work per other solutions I have seen.
See attached spreadsheet.
Bookmarks