Excel Waterfall Chart - change value of horiztonal gridlines

[Pbas1968]

using the waterfall feature in Charts.  the spread of my horiztonal lines is $100,000 - I would like it to be every $500,000.  I have watched several videos where the value can be manually changed.  I do not have that option. Any suggestions?

[JonPeltier]

I wonder why this was marked 'solved'? The user asked for Excel, and the response was for Power BI Desktop.

The answer is that in Excel, waterfall charts cannot be as completely formatted as regular charts (long story). The major unit (distance between gridlines) cannot be modified in a waterfall chart.

[rajendraongole1 · Accepted solution]

Hi @Pbas1968 -Horizontal lines (also known as Y-axis intervals) in Power BI's Waterfall

On the right-hand side of Power BI Desktop, ensure that the "format" pane is visible. 

horizontal value (y-axis):

Hope this helps.