View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
troubled excel user troubled excel user is offline
external usenet poster
 
Posts: 2
Default merged cells and creating charts

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