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.
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 again
thanks again
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.