Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 20 Apr 2018 04:38:38 +0200Sum values by date numberhttps://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/ I have some financial data I'd like to process and graph. I have the transaction dates formatted as numbers, such that the first day in Quarter 2 is '1' and the last day will be '91'. The values for the transactions are in adjacent columns, and there are multiple accounts with databases formatted as such on the same sheet.
I have for each account a running balance, such that there are multiple values for the balance of the account in a day if multiple transactions occurred. I have learned how to graph these running balances, but I am having difficulty creating a formula using functions to create the most important curve in my graph, which is Net Worth (Acc. 1 + Acc. 2 - Acc. 3... and so on).
How do I create a function to render the data for graphing Net Worth?
![image description](/upfiles/15241914605498097.jpg)
Here is an illustration of my planned graph, the entire purpose of the spreadsheets.
I could easily do it on paper, but that is wasteful and time-consuming to manually calculate and sum all of the values, and then plot them on paper of digitize the values and plot it with Calc thereafter.
In the end, when a TODAY function is called, I want it to check if a an earned, but unpaid/unreceived asset should have liquidated (pay-day) and to see if an unearned, scheduled, potential asset (a future workday) has passed (becoming a virtual or gaseous asset, rather than a nebulous one in my terms).
This will allow me to see the sum total of my finances at a glance, historically and in the near future for the purposes of large bill payments and savings deposits, as well as make projections for when I can expect larger lump sums if my budget is followed and discretionary expenses eliminated.
Any help is appreciated,
Thanks in advance!CyberxineFri, 20 Apr 2018 04:38:38 +0200https://ask.libreoffice.org/en/question/152753/LO calc line chart single data point labelhttps://ask.libreoffice.org/en/question/141909/lo-calc-line-chart-single-data-point-label/I can add data labels to all points on a line. Can I, and how, add one data label to the end point of the line?Christopher WhitmeySat, 30 Dec 2017 15:54:42 +0100https://ask.libreoffice.org/en/question/141909/How to use "assume zero" on data series without messing up dates?https://ask.libreoffice.org/en/question/138385/how-to-use-assume-zero-on-data-series-without-messing-up-dates/Hello everyone,
I'm trying to use 'assume zero' on data series in a chart with dates on the x-axis.
Whenever i try to use it the x-axis get's messed up and shows dates starting with 1999 instead of the entered values.
Is there a trick, so it only shows the entered dates?maxbSat, 18 Nov 2017 16:33:24 +0100https://ask.libreoffice.org/en/question/138385/Unable to adjust X-axis labels and tick marks (timestamp) in a Calc line charthttps://ask.libreoffice.org/en/question/129436/unable-to-adjust-x-axis-labels-and-tick-marks-timestamp-in-a-calc-line-chart/ Hi,
I'm charting date & time based data in a line chart (e.g. 1-minute samples over a 24 hr or 48 hr period, = 1,440 samples/24 hr). The X-axis displays date and time. The X-axis labels that are displayed are set automatically. I can't adjust the start of the labelling (it now displays a start time of 16:02, where it should be 16:00), and the interval is set automatically (e.g. 27 minutes) and can't be adjusted. I would like to format the axis to start with the 1st sample as label, and manually set the interval of both the labels and the tick marks. I formatted the X-axis timestamp both as text (=text(REF),MM-DD-YYYY) and as number. It doesn't produce a different result.LibreHenkThu, 07 Sep 2017 19:37:46 +0200https://ask.libreoffice.org/en/question/129436/Calc chart "same" value date X axishttps://ask.libreoffice.org/en/question/8332/calc-chart-same-value-date-x-axis/hello
I am trying to do something for work, and I've been getting problems with the chart, actually how it's drawn.
I have X value with a lot of same dates and
Y value with numbers
The problem is that I want all the X and Y to draw separate, not multiple dates (X) with multiple numbers (Y).
Is that possible?
Attached the simple calc file so you see what I mean.
http://www.filedropper.com/test_13
EDIT:
It works in MS Excel.. should look like this:
http://www.filedropper.com/book1_4mkrmecWed, 28 Nov 2012 12:55:07 +0100https://ask.libreoffice.org/en/question/8332/