How to make Line Charts automatically not start from 0?
Hi guys, I am working on a calculator made in excel. It pulls the data from one sheet and in another one it displays some kpi summaries, insights and line charts.
I am not happy with how the line charts look like because it always starts from 0 and my line is sitting on the top third of the chart, while the bottom two thirds are just empty space.
I tried a few things, such as adding helper columns in the chart and making them invisible, to automatically adjust it every time new data is uploaded but the min is always 0 and I have control over the max only, which lowers the position of the line but makes it even more straight so it's still unappealing.
I do not want to use VBA as it's something we are sending to clients, and if they do not enable macros then it's for nothing.
Are there any solutions you guys might know?
I am using the desktop version of excel, on mac.
Thank you
[link] [comments]
Want to read more?
Check out the full article on the original site