Logarithmic Chart with Additional Y Axis

Hello All,
I am trying to create a logarithmic chart in Excel with a data set which I have done here:
Screenshot 2019-11-13 at 11.15.32.png

However as you can see there are only lines visible at the major data point nodes. What i'd like to do is make the Y Axis lines on the chart look a bit more like this:
Screenshot 2019-11-13 at 11.18.13.png

As you can see, there are a lot more lines spanning the Y Axis so it would be easier to read the data off the chart.

I have tried a few different ways of playing around with the base and then the major and minor bounds but can't seem to get anything to look like the second image.

Any help would be appreciated,
Thank you!

Example Sheet: Example Sheet.xlsx

Hi
Please read the yellow banner. Thanks

Don't you see a yellow banner indicating how to post a sample sheet?

OK I thought it was a glitch. Many new members tend to ignore it which slows down the help they might get

After fiddling with the chart in your sample file a few times, I discovered that your minor unit vertical gridlines are formatted to be white. White against the white background of the chart does not show up. I selected the vertical minor unit gridlines and formatted them to be colored black, and they appeared. Is your question as simple as changing the color of those gridlines, or is there more to your question?

I don't know exactly how this will work in your version of Excel. In my version I:

1) Select the vertical minor unit gridlines. Because they are essentially invisible, I could not select them by pointing and clicking with the mouse, so I
1a) Select the chart to bring up the Chart tools ribbon.
1b) In the Format menu, there's a dropdown listing all of the available chart elements. In this dropdown, I select "Horizontal (Value) axis minor gridlines".
1c) then click on Format Selection (still in the Format menu) which brings up the format dialog.
2) In the line color section of the dialog, select the appropriate options (Automatic if I want to let Excel choose the color or select a color from the palette if I want to choose the color).

I don't know exactly how your version will accomplish the same steps, but I expect there are similar tools at your disposal.

Assuming I understand what you are seeing and what you are trying to do, I will try to explain what I see.

Assuming I found the same youtube video (https://www.youtube.com/watch?v=HLXGVlvjzcA ), the big difference I see between his semi-log chart and yours is that his x axis/data spans multiple decades (from 10^0 to 10^5). Your x axis/data spans 1 decade (10^-2 to 10^-1). Excel's logarithmic axes are limited in that (at base 10), it will only show you a maximum of 10 minor units per decade. The youtuber's chart is limited to at most 10 minor units per decade, and your chart is limited to 10 minor units per decade. The only reason his looks better is that his chart shows multiple decades.

Assuming the real question is, as I've assumed, how to get more divisions per decade, I see two possible approaches. 1) Use a different charting application that has greater flexibility with logarithmic axes or 2) build your own axis/gridlines (from stuff you have lying around the spreadsheet). I have limited experience with 3rd party charting applications, but expect that you could find one (especially if you were willing to pay for it) that would give you greater flexibility. If you decide to go beyond Excel's built in limitations, the technique I would expect to use is the one described here: https://peltiertech.com/reciprocal-chart-axis-scale/ As he notes in the title, he is specifically creating a reciprocal (1/T) axis, but the same technique should easily adapt to your scenario involving a logarithmic axis.