Forum Discussion

Jon Cutting's avatar
Jon Cutting
Copper Contributor
Jan 22, 2021

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 chart, it looks like this...

Notice that now there's a space between the columns and the top of the data table. How do I get rid of this whitespace?

5 Replies

  • Jon Cutting 

     

    For the first char, you need to select the chart and resize the columns area, you might need to remove the chart title or move it somewhere else.

    For the second chart, you need to reduce the axis X maximum value since there is no value more than 10 in your chart,

    select the X axis values in the chart --> on the right panel go to Axis options --> change the maximum value to 10
    To remove more space do as mentioned for the first chart.

     

    • Jon Cutting's avatar
      Jon Cutting
      Copper Contributor

      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.

      • JennaShenton's avatar
        JennaShenton
        Copper Contributor

        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.

    • Jon Cutting's avatar
      Jon Cutting
      Copper Contributor

      Hi, SergeiBaklan 

      Sorry, I think I explained my question poorly. I want the columns to stay the way they are. See how the bottom of the columns touch the top of the data table here?

      And see how there is whitespace between the bottom of the columns and the top of the data table here?

      I want to remove that whitespace. How did the first chart get that whitespace removed?

Resources