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
Hi, yes, my problem is solved. CMD+Tab now works within the screen you are sharing! But, now of course, there's another issue. How to leave the shared screen using the keyboard? Meaning, how can I switch controls back to my own Mac using the keyboard [More]
If you've ever tried troubleshooting the problem of your Mac not going to sleep after the period of inactivity that you have set in System Prefs, you know what I'm talking about. I've had this problem off & on for years and I have it again now. I can [More]
After many months or enduring OD issues, I finally decided to bit the bullet and do a fresh install of both Mavericks and Server.  After the fresh install, I attempted to re-establish the Open Directory Master from an archived version of OD and it fa [More]
Hello, in our company we have problems with Adobe Reader 10.1.2; these are the information I think you need to help me in this case. If you need more informations please let me know. Problem: Printing of PDF-Files is not possible, Reader crashes. Ins [More]
After I enter my password for log in, the Editor will not openYou have a reply from an adobe staff member in your other thread: Photoshop Elements 12 Editor will not open from OrganizerRead other 2 answers [More]
Hello, We are having issues with uploading and downloading attachments using JSPWiki using IE browser. It works perfectly with Netscape/Mozilla/Flock browsers. jspwiki.properties -> we set the following attributes: jspwiki.baseURL = http://localhost: [More]
Hi,  I have the data in Excel(sample.xls). there are 2 columns of data. I want to read the data from excel and display in the form of XY graph (x-axis -one column of data and Y-axis one coumn of data). can anyone please provide the VI for this or els [More]
I have a TXT file in my application folder.. I have not added it into the resource.. How can I access this file. I do not want to add this file to resource. Your help will be appreciated.I don't think i  migrated anything over, i had a bit of trouble [More]
What's the point? I move a mail on my iPhone when I am away to another IMAP folder and when I come back sitting in front of Mavericks opening Apple Mail the mails should be there where they belong to. Or what's the concept here? If that's not working [More]
My printer is being recognized but says driver unavailable...what can I do?Hi tmad, Welcome to the HP Forums! I see that you are trying to find a driver for your printer, and I am happy to help! For further assistance, I will need to know the followi [More]