Not an option in this case, I require the formatting to remain (took weeks to
get it functional as is).

So what you are saying is don't use built-in functionalities?! Great,
another great MS'ism! I paid for software, that you are saying doesn't work
properly.

QB




"David Biddulph" wrote:

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


.