Forum Discussion
scatter plot line problem
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.
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?
Remediation301 What is the chart type? The option "Connect data points with line" is not available in column and bar charts, for example.
- Yeah that works. Thank you. How obscure. I have used Excel since its beginning and done lots of plots. This must be something new... but it does get the result that I wanted.
thanks againThe 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.
