Periodically in Tableau, the ‘edit axis’ option doesn’t provide the level of control required to communicate the trend of your line chart. When we ‘include zero’ on the chart, we end up with too much white space under our chart, making the trend hard to conceptualise.
Counter wise, when we uncheck this option we see an over emphasis of the trend of our chart.
‘Fixing’ the axis is a workaround for a static data set, but when our data is dynamic, it can result in our chart disappearing off the screen.
This video provides some tips and tricks to help you overcome this issue and provide more control over the y-axis range, demonstrating the line chart trend that you’re looking for. Perceptive Data provides Tableau consulting if you need assistance with data visualisation development.