The data for the 2 columns have to be next to each other. Otherwise
Excel will consider the gaps in the data as data points with zero
value.

Or, hide the rows (columns?) with the missing data - assuming you can
hide those rows. The default in 2007 is to not show data from hidden
rows.

On Thu, 15 Oct 2009 08:18:54 -0700, Lozzaw
wrote:

Hi

This seems like it should be simple but is not. I have created an Excel 2007
coulmn chart. I then modify the data the chart uses so it is only using 2
columns of data, not 5 and the 2 columns are not next 2 each other.

Fine, I've now got the chart showing the data I want, but I'm left with a
big space where the 3 columns were previously, on the right of my chart.

How do I get rid of the empty columns so my chart fills the plot area fully?

Thanks
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins