How do I hide gaps in an Excel 2007 chart?

  • Thread starter Thread starter Waynesch
  • Start date Start date
W

Waynesch

I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
 
Hi,

If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.

In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
button.

Cheers
Andy
 
Back
Top