•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to make Line Charts automatically not start from 0?
Our take
Creating visually appealing line charts in Excel can significantly enhance the presentation of your KPI summaries and insights. If your line charts are defaulting to start from zero, leading to excessive empty space, there are effective strategies to adjust the vertical axis. Rather than resorting to VBA, which may complicate usability for clients, consider utilizing Excel's features to set a dynamic minimum value based on your data range. This approach ensures your charts accurately represent trends while maintaining a professional look.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Font formatting of a calculation dashboard KEEPS reverting every time the data in the other sheets is updatedI am at my wits end, every time I open this spreadsheet the formatting of these cells (supposed to be large and extremely readable to low-tech users on same team) reverts back to Calibri size 11 for some reason. I even created a custom cell style to try and force it to stay that way and I can see that it's selected in the menu, but not reflected whatsoever. Is it just impossible to format cells with a constantly changing calculation? What can I do here?? I feel like I have gone through every formatting constraint/rule there is to try and force it to behave but it always changes back, even if its not right away. It's a spreadsheet stored on sharepoint primarily but I don't know if that makes a difference. Advice appreciated. 😞 submitted by /u/vailette [link] [comments]
- Rearranging data to make a line chart with multiple seriesI want to make a set of line charts with multiple series each with the following: Sampling Date is on the x-axis | SSILT63_2 (%) (or any variable from columns C-E) is on the y-axis, and each series in the chart is named after the different points in Column A. I tried selecting Columns A-C to make the first chart, but instead of making multiple series, it made a single series instead. https://preview.redd.it/jnkd63xgmcwg1.png?width=3174&format=png&auto=webp&s=9e4bcaebafddd8bbbcf875d14e53b1e87a8a83bb It works when I transpose the data with the points as different columns and the dates as the rows, but the issue then is that I have to manually arrange it, which takes a lot of time for a single variable. https://preview.redd.it/cfn4ay6jpcwg1.png?width=2682&format=png&auto=webp&s=899d24ad87eda26956b8e22f24655ec5a0f68f5e I am wondering if there is a function or feature to either: * Have Excel recognise different series from Column A in image 1 * Quickly / automatically rearrange the data from image 1 to look like the table in image 2 Edit: I am using Excel for Mac, Version 16.108 (26041219) submitted by /u/Real-Alternative-653 [link] [comments]
- Resources that help you get better at laying out Excel spreadsheets?When I have the opportunity to see someone else's sheets, sometimes I feel like "oh that's a better way to lay out the inputs v data/calcs. I'm comfortable with the data and formulas used, but I always feel like I could use improvement in laying out my information for others to understand. My brain thinks about in one sequence but that may not be the same for others. Are there any resources you've used that helped you get better at synthesizing the building of your workbooks? submitted by /u/brooklyn735 [link] [comments]
- Is there a "cleaner" way to make graphs from an equation/calculation, rather than using columns filled with data?Out of curiosity, I want to make a graph showing progressive tax rates. I'm able to do this by creating calculated columns of data and making a graph from that (which is sufficient), but I was wondering if Excel has any way of entering a equation or calculation and making a graph from that. (If not, any basic software recommendations that might be more appropriate?) submitted by /u/i-love-dregins [link] [comments]
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