How do I hide gaps in an Excel 2007 chart?
 

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.

How do I hide gaps in an Excel 2007 chart?
 

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

Waynesch wrote:
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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

How do I hide gaps in an Excel 2007 chart?
 

Consider leaving those empty cells REALLY EMPTY (no formula no white colored
text) OR fill those cells with an NA() error.
http://img130.imageshack.us/img130/3036/nonamed.png
Micky


"Waynesch" wrote:

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.