Hi,

Charts do not understand merged cells. Each cell contains a value even
if 2 of those cells are not displayed.

Create a contiguous range of data for the charts.

Cheers
Andy

On 24/02/2010 04:19, QB wrote:
I am using a set of merged cells as a data source for a line chart. However,
I am getting empty/null entries as part of the data set from the merged
cells???

Basically, I have a set of merged cells each consisting of 3 cells. When I
create the data source I get values like:
73%,,,61%,,,...

Why is it making up value for each cell even though the cells are merged
together???

I am truly finding 2007 very frustrating and very counter-productive!

Please help,

QB

--

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