Calc Table - Creating a Projected Line in a Table

[dnder]

I track my expenses and balances in my checkbook twice a month. However, I missed my data points in January. Instead of seeing my chart drop to zero and then right back up, how do I get the chart to show a projected (dashed?) line for each data point?

(The entries you see below create the red line and the green line. The other lines are created above, but didn't have the space in the screen capture I was able to grab. The red row creates the red line. The very bottom line of figures creates the gold line on the table. I've screen captured the formula I'm using for the gold line.)

NOTE: I've corrected the error (seen in the formula) that prevented the displaying of the dates. I now see the bottom of the chart read 1/1 and 1/15 and 2/1.

[phpistasty]

Not a solution, but this seems similar to a post I just made.

http://www.oooforum.org/forum/viewtopic.phtml?t=141666


Hopefully someone has a solution.

[phpistasty]

I think I figured something out.

When editing the graph (double click on it) and then double click on the line. I'll open a Data Series dialog. Under plot options there is continue line option.

I think to make it dotted you'd have to specify another dataset. You can then make this segment dotted by double clicking it through the same dialog as above, and choose the style under the line tab.

[dnder]

I tried "continue line," as suggested. The graph did not change after making this setting.

[dnder]

I did find this article that talks about adding a function to your formula.

That is something I've never done, and would not know how to apply it properly. (I tried.) Does this make sense as a solution that someone could walk me through implementing?

[dnder]

And I'll attempt one bump, to see if anyone has any new ideas, please.

[jrkrideau]

[ken johnson]

See if this is what you are trying to achieve...
http://www.mediafire.com/view/?z0ju5979amv4j3f
The line chart has two series...
1.The original data with some blanks in the y values
2.The original data with the blanks replaced with calculated interpolated values.

The "Leave Gap" option is used, the first series has a solid line and visible markers, the 2nd series has a dashed line and no markers.
If both series are the same colour the order of the two series does not matter. If the two series are different colours then you will need to have the 1st on top of the 2nd.

I have used 5 helper rows to arrive at the calculated values for the 2nd series.
Two of the helper formulae are array formulae.
Array formulae must be entered using the Ctrl+Shift+Enter PC key combination, and the Ctrl key must be held down while dragging the fill handle to fill an array formula into adjacent cells.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).