Firstly, thank you for trying to help.

I will lookup/look into 'contiguous range' and see what I can do with that.

Also, as an FYI, I just tested merged cells on Excel 2003 and they work just
fine! It is solely an issue in 2007. Another improvement that was made
between versions by Microsoft...

QB




"Andy Pope" wrote:

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

.