Hi,

You need to divorce the required data layout for chart with your
'pretty' presentation layout.

If your data is in A1,D1,G1 etc then elsewhere on the sheet, or another
sheet, use formula to link cells.

A10: =A1
B10: =D1
C10: =G1
etc

Then chart A10:C10...

Cheers
Andy

On 24/02/2010 13:14, QB wrote:
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


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


.


--

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