Results 1 to 11 of 11

Need to update my cumulative plot - new values, columns - without affecting data

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2008
    Location
    Perth Aus
    Posts
    16

    Need to update my cumulative plot - new values, columns - without affecting data

    ...and its turning out in the opposite direction it should!

    I am trying to make a couple of plots, but they are not looking like some examples I have.

    In the attachment is my data. I need to make 2 plots (though once it I figure out how to to do the first one I should be ok).

    Plot 1: Resource Grade (log scale) against the proportion of deposits (linear scale)

    Plot 2:Tonnage (log scale) against proportion of deposits (linear scale)

    They are meant to cumulative proportion plots. As a line or scattergram. An example of what they are meant to look like is at: http://www.nbmg.unr.edu/dox/ofr962/c11.pdf on Page 4 and 5.

    My main problem is that my curve always turns out in the opposite direction to those above. I use Data Analysis > Rank and Percentile to get the cumulative list. (Not sure if that is even the right method)

    "Proportion of deposits" is supposed to be a cumulative percentage, so I guess i need know how many of the same number there are, and find out their proportion to the overall.

    e.g . all the deposits together = 100%....3 deposits have a tonnage = to 1.5 t which together represents 2% of the total deposits tonnages at a cumulative proportion rate of 12.9% (f I add all the ones below it). I just did that my calculation, though im sure there is an easier way in excel....and thats what im trying to do, and make a plot of them.

    Anyone have any idea....or am i even confusing myself?

    Btw the way im new....so hello! And....I have posted on another forum for help, as its 4.30am, and this assignment is due in 3 and half hours...aha...
    http://www.mrexcel.com/forum/showthr...=1#post1716732 Link to other forum
    Attached Files Attached Files
    Last edited by Macca1888; 10-23-2008 at 08:00 PM. Reason: Because i needed to link my post on another forum...to my thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multivariable Scatter Plot
    By Soloman in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 04-24-2012, 11:40 PM
  2. Finding starting point of chart plot area
    By rweatherly in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-17-2008, 10:54 AM
  3. Automatic plot a excelchart against a timeline
    By cavr911 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-01-2008, 08:03 AM
  4. plot: X vs Y by category Z
    By rjandino in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-01-2007, 08:40 PM
  5. Scatter/line plot - all axis - different units on x2, y2
    By L-TMC in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-06-2007, 06:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1