Hi there. I'm creating line graphs in Excel, where each record does not necessarily have a value for each point on the X-axis. The X-axis is date, the Y-axis the value that appears on that date. Measurements for each record were taken on different dates - hence every point on the Y only has some values.
When I create a line graph from this, on the point for which there are null values, the line returns to zero. This gives a totally misleading picture.Please Login or Register to view this content.
What I want is for that line to simply skip a value for that date, and continue straight to the next actual value. Can anyone suggest a solution?
Bookmarks