•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating graphswith empty cells.
Our take
Creating graphs with empty cells can be challenging, especially when you want to visualize cumulative spending without interruptions in the data. In your case, where a weekly data array tracks quarterly spending, it's essential to ensure that the line graph reflects only the available data while leaving space for future entries. To achieve this, you can modify your chart settings to handle empty cells appropriately, allowing the line to continue without dropping to zero.
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- PQuery / Data models: Dynamic table changing format when encountering null/empty valuesHi all, hoping the community can give me a hand. As the title says, I have a dynamic graph that plots data from a query in the data model, but when it encounters empty or null values it resets itself. Pre-empty values Empty Values Post empty values I already tried changing advanced graph settings "Properties follow data points" to no avail. Also, since im working with external queries I do not know if I can and should modifu the whole data structure to change null/empty values (it could be more bothersome for other effects). Hope the community can guide me on this issue! submitted by /u/Far-Aspect-2022 [link] [comments]
- Stacked scatter plot with same y-axis for readabilityIm working with SCADA and pulling together data from a model to compare the 2 at a couple of different locations. Is there a way to stack 3 graphs in excel without completely manually doing it? the data is all for the same week in sub minute increments, so needs to be a scatter plot. and y-axis is all the same so its not a like a secondary axis is beneficial in this case. below is the plots with all the data, very hard to parse unless someone explains what's going on. https://preview.redd.it/cgyalit9wyzg1.png?width=1426&format=png&auto=webp&s=b03a3d9022a3efc482d6d3161a52186c1c745f36 below is what I'd like the graphs to look like, done in ppt. Kind of annoying to do manually and there's a couple of other locations I need to do this for, so if there's a better solution, let me know! https://preview.redd.it/9003h0vwvyzg1.png?width=848&format=png&auto=webp&s=e5af1d78cde58175ed5451fbb4e85f06a4f89815 submitted by /u/MyGoddamnFeet [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]