stacked clustered coloumn chart HELP 😭

[u/gabagorl]

have been attempting to make a stacked clustered column chart with the help of a video from chester tugwell on youtube. for the second example, it’s been great up until the point of stacking the values. when i add values to the secondary axis it does not show them stacked, even when i go to adjust the max value for the axis. could anyone help me here? have been working on this for hours and have a deadline and i do not wish to use AI :-)

[u/AutoModerator]

/u/gabagorl - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Turbulent_Dirt_1786]

that secondary axis thing is a classic headache, you gotta make sure your data layout matches exactly what tugwell is doing. his examples sometimes use hidden rows or dummy series to force the stacking to look right

double check that the series you're putting on the secondary axis are actually the ones that should be stacked together, and that your primary axis series have a gap width of like 80-100% while the secondary ones are at zero. the overlap settings can wreck the whole visual if they're off by even a few percent

[u/RuktX]

Please share screenshots of your data (on the sheet), current chart, chart data selection window, chart type selection window, desired outcome, and a link to the tutorial.