View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
QB QB is offline
external usenet poster
 
Posts: 57
Default Excel 2007 - Merged cells as data source

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