Forum Discussion
Having Problems Putting Two Line Graphs Together
"Why would Excel arbitrarily draw a line for only part of the data points shown on the graph?"
You need to explicitly tell Excel what to do with gaps in the data series. Go to "Select Data" and click the "Hidden and empty cells" button. Choose to fill the gaps with a line. This is valid for both lines.
As to why the first data point is not shown, you axis starts at 10, rather than zero. Are you sure the zero-hour values are part of both data series?
"Why would Excel arbitrarily draw a line for only part of the data points shown on the graph?"
You need to explicitly tell Excel what to do with gaps in the data series. Go to "Select Data" and click the "Hidden and empty cells" button. Choose to fill the gaps with a line. This is valid for both lines.
As to why the first data point is not shown, you axis starts at 10, rather than zero. Are you sure the zero-hour values are part of both data series?
Riny_van_Eekelen Your suggestions solve the problem, thanks.
I removed the zero-hour data point since all yogurts start with the same milk. The data does not get interesting until about 10 hours into the ferment, as the acids released by the active culture bacteria start to shift the pH lower.
