I'm looking to create a "line chart" graphing values over time. The xaxis precision needs to be "per day", and the period is 3 years, but there's really only a couple "data points".
What is the best strategy to create such a chart? A traditional "line chart" seems like it would need 365*3 "data" values, where most are "null". I may only have 3 actual data values over the entire period, the first value, the max value and the final value, but I need to show the precision of the specific day on the xaxis. If I created a traditional "line chart" and provided 3 data values, the xaxis would simply divide into 3 "labels". I want the xaxis to show a time period of 3 years where on some particular day, a value is set. Then a line is drawn from the origin to that data point and then to the final data point (at the 3-year mark).
I also don't really want the the xaxis labels in "days". I really want to label it in years, showing "0", "1", "2", and "3".
Scatter plots have a better notion of sparse data, but I need the lines to connect the points. Any ideas on the best strategy to get what I want?