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

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?

Our take

Creating a chart to visualize your monthly amounts by year can significantly enhance your data analysis. To achieve this, start by organizing your data to ensure that each month's totals are clearly defined and positioned next to each other for easy comparison. Use your spreadsheet software's charting features, selecting a suitable chart type that emphasizes these monthly totals effectively. Focus on clarity and simplicity, ensuring the chart conveys the necessary information without unnecessary details.

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]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#rows.com#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#real-time data collaboration#financial modeling with spreadsheets#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#chart#amounts#month#year#data
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? | Beyond Market Intelligence