+ Reply to Thread
Results 1 to 2 of 2

how do i compile a cumulative sum graph?

  1. #1
    spazaloikins
    Guest

    how do i compile a cumulative sum graph?

    i have been trying to figure out how to make a cumulative sum grqaph from
    data in excel which seems impossible. I have 2 lots of 400 pieces of data
    therefore am hoping to be able to do it on a computer rather than having to
    do it by hand!

  2. #2
    Jon Peltier
    Guest

    Re: how do i compile a cumulative sum graph?

    If you can compile the numbers into the sheet, then you can chart them,
    but you can't expect the chart to do the calculations. By "cumulative
    sum" I assume you mean some kind of running total. In the column of
    cells next to the data, put a formula that produces the running sum.
    Then instead of plotting the original data, plot the calculated sums.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______


    spazaloikins wrote:

    > i have been trying to figure out how to make a cumulative sum grqaph from
    > data in excel which seems impossible. I have 2 lots of 400 pieces of data
    > therefore am hoping to be able to do it on a computer rather than having to
    > do it by hand!


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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