OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Calc Table - Creating a Projected Line in a Table

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
dnder
General User
General User


Joined: 28 Apr 2011
Posts: 12

PostPosted: Mon Feb 13, 2012 10:17 am    Post subject: Calc Table - Creating a Projected Line in a Table Reply with quote

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.




Back to top
View user's profile Send private message
phpistasty
General User
General User


Joined: 13 Feb 2012
Posts: 5

PostPosted: Mon Feb 13, 2012 7:23 pm    Post subject: Not a solution... Reply with quote

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.
Back to top
View user's profile Send private message
phpistasty
General User
General User


Joined: 13 Feb 2012
Posts: 5

PostPosted: Mon Feb 13, 2012 7:31 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
dnder
General User
General User


Joined: 28 Apr 2011
Posts: 12

PostPosted: Tue Feb 14, 2012 6:34 am    Post subject: Reply with quote

I tried "continue line," as suggested. The graph did not change after making this setting.
Back to top
View user's profile Send private message
dnder
General User
General User


Joined: 28 Apr 2011
Posts: 12

PostPosted: Tue Feb 14, 2012 2:18 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
dnder
General User
General User


Joined: 28 Apr 2011
Posts: 12

PostPosted: Wed Feb 29, 2012 10:36 am    Post subject: Reply with quote

And I'll attempt one bump, to see if anyone has any new ideas, please.
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Thu Mar 01, 2012 12:40 pm    Post subject: Reply with quote

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


You have the data point set to zero ( a valid number). Set it to blank (missing) an the continue line option shoul work.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Fri Mar 02, 2012 5:54 am    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group