•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What kind of table do I need to set up to create this kind of chart?
Our take
To create the chart you're envisioning, you'll need a straightforward table structured with eight rows of data. Each row should start at zero income, followed by two plateau income values, and conclude with a phaseout leading to a maximum income eligibility. This setup allows for a clear visual representation of income transitions. For added clarity, consider referencing interactive elements from the Tax Policy Center for detailed insights.
Each line starts at zero income, has a plateau of two income values and then a phaseout to a maximum income eligibility. I'm assuming this is eight rows of data.
Reference: https://taxpolicycenter.org/briefing-book/how-does-earned-income-tax-credit-affect-poor-families which has some "hover over" interactivity for additional details on data. To clarify, I'm just trying to make a low-frills chart in excel.
Thank you!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- I want to create a chart like on the first photo with the provided data on the second photo. How do I go about doing that?I want the chart to add all my amounts per month per year, but each month per year to be next to each other. The description from the table is not necessary in the chart. https://preview.redd.it/8e8eiva05ryg1.png?width=784&format=png&auto=webp&s=8f50f1ce1e5038aad458133ba165124f62acb6d9 https://preview.redd.it/qsn12va05ryg1.png?width=710&format=png&auto=webp&s=2e3a0ecd4c451f92fca07ddfc9e7aee1aaf5e308 submitted by /u/Xepherious [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]
- 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#rows.com#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#natural language processing for spreadsheets#row zero#income#excel#chart#data