This is an Eval Central archive copy, find the original at freshspectrum.com.
This video is for all the people commenting “Not Useful” on my video about gap width… I think I found your problem.
The “I don’t feel like watching a video right now,” summary.
In this video, Chris dives deeper into his previous video on removing gaps between bars in Excel charts (https://www.youtube.com/watch?v=wAgjY…), addressing the issue of why the gap width setting sometimes doesn’t work as expected. He explains that the culprit can be hidden blank rows within your data table. Even though these rows don’t have any data, Excel still factors them in as spaces on the chart, creating gaps between the bars.
The solution is simple: remove the blank rows from your data table. Once those are gone, setting the gap width to 0% will truly eliminate the spacing between the bars, achieving the desired effect.
This video serves as a helpful follow-up, clarifying a potential hurdle viewers might encounter when trying to implement the gap width technique. Remember, if you’re still struggling with gaps after removing blank rows, feel free to leave a comment below the video for further assistance.