Creating a scatter plot in Excel can be challenging when referencing points from a different sheet, especially if there are merged cells involved. Merged cells often complicate data plotting, and users may encounter limitations when referencing more than eight cells. In this discussion, it was noted that long sheet names could also contribute to issues, as they might get truncated during import. However, changing the tab name to a shorter version resolved the problem, allowing the chart to be plotted correctly, even with merged cells. This highlights the importance of both cell merging and sheet naming conventions in Excel when creating scatter plots.
