Sitemap

Amicuk Programming Answers

3D Area chart with incremental sum

-0001-11-30   Views:0

Advertisement

Hi all, I am quite new to Numbers, but I found it to be extremely powerful in keeping control of my activity, especially if used with iCloud. In this case I have a spreadsheet with all my recorded invoices. This is, roughly, the structure: invoice id

Hi all,
I am quite new to Numbers, but I found it to be extremely powerful in keeping control of my activity, especially if used with iCloud.
In this case I have a spreadsheet with all my recorded invoices.
This is, roughly, the structure:
invoice id
amount
sent
payed
201301
1000
12/06/2013
11/11/2013
201302
1500
14/07/2013
09/10/2013
201303
2000
15/08/2013
201304
3000
20/08/2013
28/11/2013
I would like to have a 3D area chart, composed by two areas.
For first area there should be 4 momentum on x-axis (but I can add invoices anytime) representing 'sent'.
At each point I need to have the incremental sum which is 1000, 2500, 4500, 7500.
The other area has the real payed amount, an in this case on x-axis it would be 3 momentum representing 'payed'.
And the same apply for the sum: 1500, 2500, 5000.
Of course I have full control on this spreadsheet, therefore if necessary, I can add tables, rows, columns to achieve my need.
I hope I made myself clear.

The replay answer
Advertisement
I think this is what you want:
Add two columns as shown (columns E and F).  I titled them "Amount Due" and "Amount Paid"
E2=IF(ISBLANK(D2), SUM(E1), SUM(E1,B2))
F2=SUM($B$2:B2)
the notation "F2=SUM($B$2:B2)" means in cell F2 type (or paste from here) the formula:
"=SUM($B$2:B2)" without the double quotes.
select E2 and F2, copy, select E2 thru the end of column F (F5 in this example), paste
make the first row a header and
make the first column a header and
now select columns A, E and F, now add a chart using the menu item "Insert > Chart > 2D Area"

Go to See the other 5 answers

3D Area chart with incremental sum

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I am quite new to Numbers, but I found it to be extremely powerful in keeping control of my activity, especially if used with iCloud. In this case I have a spreadsheet with all my recorded invoices. This is, roughly, the structure: invoice id[More]

Pie Charts show Table Sum?  Huh?

Category:DefaultRelease time:-0001-11-30Views:130

Hello all. I am making a simple home budget, with a table of data, which has a final row that totals the previous entries. I selected a pie chart to show this info, but the pie chart includes the total row data, which makes no sense. How do I tell Nu[More]

Chart Query and Failed to parse SQL query

Category:DefaultRelease time:-0001-11-30Views:130

Hi, first of all, this is not a question. It is a reminder for me and maybe for someone with the same problem. I just fell over this for the 123124 time. I have a 3D Chart Query select sum(order_ok) value,       count(*) maximum_value from      v_dia[More]

Summing Parameter Values ?

Category:DefaultRelease time:-0001-11-30Views:130

Post Author: Jedit CA Forum: General I have a sub report passing values to my main report as a shared numberVar The sub report is in detail section A, the value returned is called linetotal & is shown in detail section B with some other values, the r[More]

Sum on Parameter field Help

Category:DefaultRelease time:-0001-11-30Views:130

Post Author: Jedit CA Forum: General I need a total sum for a shared number variable let me explain. I have jobs (JWO-1,JWO-2 JWO-3 etcu2026..) that have items being scrapped at different operations. I have a main report that shows all jobs with scra[More]

Spinning beachballs, slow machines, and vanishing free RAM

Category:DefaultRelease time:2015-10-11Views:130

I have a tale to tell and a question at the end. I have an iBook G4, running OS10.3.9. I have been using it without major problems for over a year. I have over 9 G of free disk space. About a month ago, with no apparent cause, I became afflicted with[More]

% Wildcard selection - extract data via Query as a Web Service

Category:DefaultRelease time:2015-10-11Views:130

Hello all, I am using Query as a Web Service to extract data through to my Xcelsius document. I have a series of charts that display summed data according to user selections within some combo boxes. Is there any way to send through a wildcard selecti[More]

How to reorder columns and make all labels appear?

Category:DefaultRelease time:-0001-11-30Views:130

I have a chart in my 2008 R2 report: I want to reorder these programs in alphabetical order and I want to display all programs.  In the image above, see how only some of the program labels appear? Here is some sample table data: create table sample_p[More]

Bug or I don't know how to use the software?

Category:DefaultRelease time:-0001-11-30Views:130

I am using shared variables to summarize data to a main report for orders (in the main report) and credit notes (in the subreport) to the main report. I then have a formula that restates the sum of my orders per salesperson, done so that I can use th[More]

Crackling noise after OS X update

Category:DefaultRelease time:-0001-11-30Views:130

hi, I have external speakers plugged into my MBP, and after the update, after a sound had been played, like a system alert or something, after a few seconds there was a crackling noise. It is as though the soundcard is turning off to save power, as i[More]

Help with programming exercise

Category:DefaultRelease time:-0001-11-30Views:130

This is my assignment: Exercise 36 � Computation Write a program that computes the following sum: sum = 1.0/1 + 1.0/2 + 1.0/3 + 1.0/4 + 1.0/5 + .... + 1.0/N N will be an integer limit that the user enters. Enter N 4 Sum is: 2.08333333333 And this is[More]

Hot
I have a 32 bit  8 channel PXI-6602 counter module.  PXI card is interfaced to PC with MXI-4 link. How can i find out the resolution and accuracy of this system.What is the maximum accuracy and resolution i will get from this system. Because optical [More]
But it will run when I click the play button in Dreamweaver... But the site will not load or run the swf file....PS... the same file runs from a hosted server, but not when the files are loaded on local machine....Read other 2 answers [More]
I have a procedure which calls a function in a query which has 2 input parameters as shown below - select a.id, a.name, a.sal, check_xyz_func(a.id, a.sal) from employees a The function check_xyz_func retiurns varchar2. Now the requirement is that few [More]
hi, i created a custom layout, now how do i make for the outbound campaings use my custom layaout? by default the outbound campaigns are using de OODefault. i  can not modify the default because i need this for another outbound campaign also. thanksG [More]
Hi, I had to change the occurences of an exisiting idoc.  I had imported the xsd,changed the occurrences and reloaded it using WSDL structure. When i load the external definition in the mapping structure, it is giving me the following error. Object E [More]
Hi Guru's I am about to create partition for my table and would like to difference between "partition column" on a datetime directly and a persisted int column. I have put the code segment here. If you could let me know the pros and cons of both [More]
Hi Guys, My apologies if this has been asked before, but I did a few searches and could not find anything. I'm trying to write an adaptor that will use/ access the information passed into a JDBC Receiver communication channel prior to the normal adap [More]
We have some old COTS software that recently started causing problems after upgrading our database from 9i to 10g (10.2.0.4) on HP Itanium server. The select statment in quesiton hits a view that references a table via a database link. After returnin [More]
How do I update iPhoto from 8.1.2 when the updater says updates complete but it is not showing as updated?How do i update it to the most current iPhoto.???? Make sure, you have a current backup of your Mac, i.e. your iPhoto Library. On no account ris [More]
I have a picture I assigned a hyperlink to and I need to change the link, but I can't get the "link to" to allow a change. I've tried checking and unchecking the boxes, but it stays greyed out.Does linking the text box still allow the mouse over [More]