With Excel 2007 as well as with earlier versions the advice stays the same.
Don't use merged cells. These newsgroups show countless reasons why not.
--
David Biddulph


"QB" wrote in message
...
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