Charting of Merged Cells
 

I am trying to create identical charts from data that isn't formatted exactly
the same. In this particular case, I'm creating charts to show the number of
defects in a given department for each month. One department may have two
machines with the total for the two merged into a single cell. Another
department may have 4 machines with the total merged into a single cell.
When the charts are created, Excel is treating the merged cells as separate
cells. For example, the chart for department with 4 machines will show Jan,
blank, blank, blank, Feb, blank, blank, blank, etc... Any ideas on how to
make the chart for the department with 4 machines to just show Jan, Feb, Mar,
Apr, etc...?

Thanks,
Zack