How do I hide gaps in an Excel 2007 chart?

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I print with hidden rows without gaps? 1
Sort numeric range and insert gaps 2
line chart (version 2007) 2
How do I tell excel not to plot certain values in a data series 1
surface chart 1
Gaps in Line Chart 4
Chart displaying "blank" cells? 13
Line Chart - Pivot Chart - Show empty cells as Gaps 2

Top