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]

---

@raynackroger login 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.

[Luis_Galvan]

@raynac 

I attached 2 screenshots of what @marcus_sommer has suggested above. You need to press and hold CTRL + SHIFT while moving or resizing the objects inside the chart. Hope this resolves your challenge

 

 

[raynac]

Hi Luis, thanks so much for drawing my attention back to this, and to @marcus_sommer for suggesting it.  When I do the CTRL-SHIFT, I do get the red boxes but the one around the chart is the full size, including the space I want to get rid of, so that didn't work.

That being said, I did some more exploration. I tried unchecking this box and, somehow, it worked!

[Nagaraju_KCS]

other way, If you encounter this issue again, try resetting the chart.

Click on "Reset User Sizing"  (The chart will be back to normal.)