This user's frustration is a perfect illustration of why traditional spreadsheets are becoming a liability for anyone who works with data. The struggle to stack bars and add totals in Excel isn't a skill gap, it's a tool gap.
Griselda_69 has a straightforward request: show In Hours and Out of Hours stacked per month, with a visible total, across multiple years. That is a common, even basic, data visualization need. Yet Excel offers no preset chart that handles it cleanly. The workaround, adding totals as separate data that then misaligns with the existing bars, turns a five-minute task into a multi-hour headache. And the real cost is worse than lost time. Every minute spent wrestling with chart formatting is a minute not spent analyzing what the data actually says. Are In Hours trending up? Is Out of Hours eating into productivity? Those questions go unanswered while the user hunts for a solution on a smartphone after hours.
This is what happens when a tool designed for static, manual workflows meets the dynamic, multi-dimensional questions we ask today. Excel's chart engine was built for a world where data stayed in neat rows and totals were calculated separately. That world is gone. Modern data is layered: time periods, categories, sub-categories, comparisons across years. A tool that cannot stack bars and add a total line without a custom macro or a third-party plugin is not a data tool, it is a legacy constraint disguised as a spreadsheet.
The practical takeaway for anyone reading this is simple. If you find yourself searching Reddit at night for how to make a chart do what should be basic, stop asking how to fix the tool. Start asking why you are still using it. AI-native spreadsheet solutions do not require you to hunt for hidden chart types or manually align totals. They understand that a stacked bar with a total is a standard request, not an edge case. They let you describe what you need, and the chart builds itself. That is the direction the industry is moving, and it is the direction that will free you to focus on insights, not formatting.
Griselda_69's frustration is not unique. It is the daily reality for millions of knowledge workers who have been told that Excel is the gold standard. It is not. It is the bronze standard, functional but outdated, powerful but punishing. The next time you hit a wall like this, consider whether the wall is worth climbing or if it is time to walk through a better door.