Forum Discussion
How to remove whitespace on chart between columns and data table
I'm creating some new charts in an old spreadsheet. The chart that was already in there looks like this... See how the columns come directly out the top of the data table? When I make a new ch...
Hi, Jihad Al-Jarady
That removed the whitespace above the columns. It's the whitespace below the columns I want to remove (please see my previous reply with the arrows). This was somehow accomplished on the chart prior, but I can't find a way to do it now.
Jon Cutting The data type for the X Axis dictates whether there is a gap or not. Time based ones will have a gap. To remove the gap, change the Horizontal Axis Type to "Text Axis" and this will remove that gap between the data table and the horizontal axis. It should keep any formatting you have applied while it was a Time based axis.