View Single Post
 
Old 09-30-2016, 07:57 PM
lbeck lbeck is offline Windows 10 Office 2013
Novice
 
Join Date: Jun 2015
Posts: 11
lbeck is on a distinguished road
Default 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
Reply With Quote