Merged cells are to be avoided at all costs.
They can be used for column heading but for little else.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Troubled excel user" <Troubled excel wrote
in message ...
I have tried to create a chart with data that is in merged cells where I
have
put in a formula to calculate the average of 4 cells in the row above.
When I
create the chart, it recognizes all 4 of the merged cells. So the graph
has 4
spaces for the data for each number I am trying to plot. I just got 2007
version and do not recall this problem at all in 2003 version