•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to get columns stacked, with the height of each being the total. Rather than separate columns
Our take
Are you struggling to stack your columns in Excel so that "In Hours" and "Out of Hours" are combined into a single bar for each month? You're not alone—many users encounter this challenge when trying to visualize their data effectively. Fortunately, there’s a straightforward way to achieve this using Excel's charting tools. In this guide, we’ll walk you through the steps to create a stacked column chart that not only displays your totals clearly but also enhances your data’s storytelling.
Hello maestros
Currently trying to finish a chart on excel here but I’m stuck
I’m trying to format it so the amount for In Hours & Out of Hours is stacked on one bar per month - for each year.
I can’t seem to find a preset chart type tha to works, and having the total added next to In Hours & Out of Hours just puts this data next to the existing bars?
Sorry for the pic quality, it’s on a work Pc and I need to solve this outside of work via smartphone’s internet. Any help is much appreciated please, cheers!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Gantt chart (Stacked Bar)Hi all, ive been trying to make a chart with no luck. The chart should show the y axis with the list off staff members and the x axis the time from 6am to 2 am. Ive made a small chart for the data of staff names, shift start time and then the duration in hours. Start times formatted to time (eg 06:30) however im not sure how to format the duration. The x axis also keeps showing time through multiple days, and the data for duration seems to stretch too far than a few hours. Any help is welcome, im not well experienced in excel so i apologise submitted by /u/tmbsketches [link] [comments]
- Stacked bar chart with multiple itemsNeed some help formatting above into 1 stacked chart if possible: X-axis: just the months Y-axis: the total numbers Stack the Active and Non-Actives on top of each other by versions ie. Forecast, Budget 2026, Q2 Snapshot and each of these would fall into a month I can do this with 3 different charts but I want to combine them into one Table Current stacked charts Ideal stacked chart submitted by /u/jaymz023 [link] [comments]
- Problem with getting charts to workHello, I am attempting to make a few charts for my assignment paper but excel is really not my strong suit. The core to my problem is I am trying to get error bars on my chart but i can't figure it out at all, any help would be useful. https://preview.redd.it/chh79lo3bl0h1.png?width=2768&format=png&auto=webp&s=820491ac27787a01c3a45f9fb4350ac02f999a69 I am happy to give more info i just really don't know what I'm doing. submitted by /u/yeeeeeeeeeen [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]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#Excel compatibility#rows.com#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#financial modeling with spreadsheets#Excel#chart#stacked columns#In Hours#Out of Hours#data formatting#preset chart type#total#monthly data#work PC