1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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

submitted by /u/Think_Jello_8525
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#Excel compatibility
#real-time data collaboration
#Excel alternatives
#data cleaning solutions
#interactive charts
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#rows.com
#natural language processing for spreadsheets
#enterprise-level spreadsheet solutions
#AI-driven spreadsheet solutions
#financial modeling with spreadsheets
#no-code spreadsheet solutions