How to remove space in a combo chart

[raynac]

Hey all!  I have a combo chart that's giving me grief.  All of my others are fine but this one has this strange gap under the bars.  Can anyone tell me how to remove all this space that's coloured in the fuchsia pink and get my bars down to the bottom where they belong? There's no negative data, so that's not the issue.

The only setting that seems to help is the Log Scale setting, but if I turn that on, the bars are no longer proportional to the numbers they represent.

Thanks for any help you can provide!

[Or]

This looks like a split axis chart, so I'd try playing around with the settings for that. 

[jamesmick]

---

@raynac wrote:

Hey all!  I have a combo chart that's giving me grief.  All of my others are fine but this one has this strange gap under the bars.  Can anyone tell me how to remove all this space that's coloured in the fuchsia pink and get my bars down to the bottom where they belong? There's no negative data, so that's not the issue.

The only setting that seems to help is the Log Scale setting, but if I turn that on, the bars are no longer proportional to the numbers they represent.

Thanks for any help you can provide!

---

You can fix that by adjusting the chart’s axis minimum. In most cases, Excel or Google Sheets auto-sets the Y-axis to start above zero, leaving that gap. Just right-click the axis → Format Axis → Set Minimum to 0. That’ll remove the extra space and align your bars flush with the bottom.

[marcus_sommer]

Maybe the parts of the chart were manually adjusted. This could be done by pressing CTRL + SHIFT on the activated chart which produced several red lines around the parts which could be sized and dragged per mouse. Restoring such measurements could be done within the object-properties in general on the bottom left.

If this isn't the cause I suggest to start to rebuild the chart from the scratch - adding the dimensions and copy & paste of the expression-strings are quickly done and then adjusting step by step the various properties. If it behaved at one point as the previous one you found the conflicting setting and could investigate it further.