How can I make a table or chart to interpolate between values?
I enjoy looking at the performance of my investments over time (not rich - just like the visual feedback). I have constructed a spreadsheet with daily entries but there are many blank rows where I haven't entered data due to inactivity (either mine or the market).
I use the Excel autofill utility for date. So when I construct a graph I get this ugly sawtooth showing zeros where there is no data. What I would like is a nice smooth line chart that connects only the positive/negative values over time.
How do I do that?
Thanks
|