Results 1 to 4 of 4

Cumulative Line Graph

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    16

    Cumulative Line Graph

    I am trying to create a line graph that charts the ups and downs of a weekly set of results.

    I have attached a set of dummy results, but imagine the weeks could co up to 52.

    So what I want on sheet 1 is a line graph that shows a cumulative running total. But I want it to split the data up by weeks and only when column D on sheet 2 equals EPL.

    Example

    Week 1(sheet 2) has 11 EPL results with a total value of 45.99. Week 2 has 18 EPL results with a total value of -14.29

    So week 1 would be on the bottom axis and would have a value of £45.99 and then week 2 would be the next point and this value would be £31.70 (45.99 – 31.70) and it would continue like this week after week.

    Is this possible to do?
    Attached Files Attached Files

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