•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can't stop graph from displaying non values as a 0
Our take
If you're frustrated by your Excel graph displaying non-values as zeros, you're not alone. Many users encounter this issue when adding new columns or formulas, especially when dealing with dynamic data sources. This can disrupt the clarity of your visualizations, making them less insightful. Fortunately, there are strategies to ensure your summed column pulls the correct values without manual adjustments. In this guide, we'll explore practical solutions to resolve this problem, helping you create accurate and engaging graphs that reflect your data's true story.
That might not be a great description but basically I have an Excel file that I didn't make but I did modify and I added a column that summed up three other columns and added it into the graph.
The problem is, unlike the rest of the graph, which clears data and then pulls from a website as I update it periodically, the column that I have that is a sum will appear as a flat 0 the whole way unless I delete it all and then drop down the cells as I go.
I think it will be easier to snip the Excel file and show it because I'm sure this will not make a ton of sense.
https://ibb.co/4R9FZCBc https://ibb.co/MxTDLPbC
Does anyone know how to handle this? It's driving me crazy to either have that bottom line there on the graph or have to manually pull down the formula each time I pull in new data..
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Creating graphswith empty cells.I have a data array I use to feed a chart. The chart is cumulative spending on a quarterly basis at a weekly level and it's reviewed every week. I have one row for each week of the quarter and the values are the QTD spending upto that week. This means that I'll only fill up the array part way during the quarter. But I want to create charts where I just select the entire array including the empty cells which will be populated with data in the coming weeks. The problem is that when I plug in the range for the line graph, the line keeps going up and then drops to zero. I don't want it to drop. I want the chart to pick up what's there, plot a line half way through and stop. With space for the next few weeks already in the axis. Any ideas? submitted by /u/procrastinator__101 [link] [comments]
- Excel seems to think cell isn't big enough so 2 digit number looks crazy, no adjustment fixes issueI have multiple sheets that add together to make a total on the first page. Easy. The numbers are small - 3, 5, 10, nothing big. On the totals sheet, all the two digit sums are wrapped so that they are very small. I do not have wrapped text on but when I DO wrap the text, it stops wrapping them BUT there's this giant space between the two digits like "1 0" for 10. I tried everything I could think of - rewriting the formula as a SUM function (rather than this sheet + this sheet + this sheet), making sure each cell is formatted as a number, running "text to column" on each column of data, switching the font, switching the font size, changing the column size manually, double clicking on the columns to have them auto size, turning off shrink to fit, turning on shrink to fit again after, playing with the alignment.... Does anyone know what is going on and how I can solve it? Adding images (w/ some edits for privacy for my company). Will include the formulas (both versions). https://preview.redd.it/6n05pqeer4og1.png?width=1654&format=png&auto=webp&s=64729e1558bfba595d7d043b18d777b3e33e4ecf https://preview.redd.it/ydydstbfr4og1.png?width=1664&format=png&auto=webp&s=27e3d7cd18c2c380a5cf1a48853060a4bcd17c7c https://preview.redd.it/7dcraf9gr4og1.png?width=1106&format=png&auto=webp&s=4c93c635fbc20762a18cc8e137b6a40ee37c470e submitted by /u/catincombatboots [link] [comments]
- Custom error bars excel problemSo I have data for a project that I made into a line chart, which took me almost 4 hours because of the fact that excel didn't want to take my data as It was, it would see it as zero's instead of normal decimal numbers. After troubleshooting that I have another problem. I have the line graph I only need to add my custom error bars. The numerical value of the numbers should be big enough to show up, but excel just doesn't want to add them. I am selecting the range and everything correctly, I've tried with completely different numbers, different graphs and converting them etc nothing works. Please help me troubleshooting I am going insane. submitted by /u/alt_bc_im_a_pussy [link] [comments]
- 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]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#real-time data collaboration#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#intelligent data visualization#rows.com#AI formula generation techniques#Excel#graph#sum#columns#data#non values#formula#update#website#displaying#modify