Scatter Plot in Excel - Referencing Cells Merged or Not

[Hootenanny]

I am trying to do a scatter plot in Excel, and I am referencing points from a different sheet. However, excel won't let me reference more than eight cells. Some of the cells are merged, I don't know if that will affect it...

Any help would be appreciated.

 

[Dr Transport]

Merged cells are a problem when plotting in excel...

 

[Hootenanny]

Thank's for the suggestion, I tried un merging the cells, and just referencing the single cells, however, the same problem occurred. I have rather long sheet names, do you think that may have something to do with it?

 

[Dr Transport]

Could be, they get truncated on the tab if you have a long filename when you import.

 

[Hootenanny]

Could be, they get truncated on the tab if you have a long filename when you import.

I changed the tab name to a shorter name and found that the chart was plotted perfectly, even with the merged cells. Thank's very much for your help