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
Hello all, I currently have a test sequence that branches off into several subsequences, which branch off, etc. Currently, I have the report options filter out to only report 'pass' or 'fail' results. Even with this, my report is 90-100 pages. This i [More]
Am using 10.8.2 and screen saver using itunes album covers do not function. Any info on this? TIA KubyAm using 10.8.2 and screen saver using itunes album covers do not function. Any info on this? TIA KubyRead other 6 answers [More]
Hi I am migrating the vmware with oracle virtula machine for that I have downloaded the OVFTool and run the following command ovftool.exe c:/../vmware.vmx d:/../vmware.ovf successfully I am able to migrate .vmx to .ovf file. then when I opened the sa [More]
Hi Is is possible to transfer cash account to Profit Centers in Classic PCA.  If i have the following entry : DR        Primary Cost Element CR        Cash Can i transfer the Cash a/c to PCA based on the Primary Cost element.  If yes, what are the co [More]
I have a page that lists the titles and teasers from other pages on the site. The title is always wrapped in the only h1 tag on the page, and the teaser is wrapped in the only h2 tag on the page, so they're easily identified. How can I pull those int [More]
Hi, We are in ECC 6.0 EHP5 SP26. We are implementing Talent Management currently. We have already configured the calibration grid, but the grid is not showing in EP. We have activated the business function and business package required : Business Fun [More]
We are going to upgrade stack level from 13 to 16. Current SP level for PI_Basis is Release 2005_1_620 Patch 13. I see Releases 2003_1_620, 2005_1_720 and 2006_1_620 in stack queue for 16 ( In service market place ). My Question is : Is it 2005_1_620 [More]
I have sound in apps, but I have no sound during phone calls. People can hear me but I can't hear them, unless I put it on speaker or use headphones. Any ideas if there's a setting I can adjust?Hi sreebabu, Thanks for visiting Apple Support Communiti [More]
I always access this website as my home page and especially to check my e-mail if available. This site is from google itself and apparently, the GMAIL widget aren't working when I clicked any mail or link inside that widget. I had to go into main GMA [More]
in both PS% and PS 6 CC the tool bar will not reveal the hidden option when I click on the little arrow...this problem just began as I have used this successfully in the past...probably a simple solutinThank you. After much experimentation I discover [More]