Forum Discussion
Solved
scatter plot line problem
I cannot create a "scatter plot with straight lines". Here is a screen shot of a plot: This is a scatter plot, but I have selected "scatter with straight lines and markers". Changing cha...
The data points for a chart series are usually in adjacent cells. If there is an empty cell in between, it often means that there are missing data. But here, there are many empty cells between the data points because of the layout of the source range. So that's different.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Thanks! There are empty cells between the data points of each series. By default, these are displayed as gaps in the chart. To change this:
- Click anywhere in the chart.
- On the Chart Design tab of the ribbon, click Select Data.
- Click the 'Hidden and Empty Cells' button.
- Select 'Connect data points with line'.
- Click OK, then click OK again.
HansVogelaarwhat if your "connect data points with line" is greyed out and you are unable to select the radio button?
