In this video, Chris dives deeper into his previous video on removing gaps between bars in Excel charts ( • Gap Width. How to get ... ), 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.
Looking to improve your data visualization and reporting skills?
View Upcoming Workshops: datavizmadeeasy.com
Check out Chris Lysy's Data Visualization blog: freshspectrum.com
Негізгі бет When Gap Width Doesn't Work
Пікірлер