Results 1 to 3 of 3

Creating Line Chart From Data

Threaded View

  1. #1
    Registered User
    Join Date
    11-30-2010
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    13

    Creating Line Chart From Data

    Hi,

    I'm sure you Excel whizzes can help me in this matter. I have created a spreadsheet which I use to track football (soccer) predictions for a little competition between friends. What I would like to do is create a line chart showing each participants cumulative score.

    I've attached the spreadsheet for you to look at. What I would like is to have the date (column B) on the X axis as a unique value. The Y axis to be the points accumulated scale and for each player to be shown on the chart with the cumulative points gained throughout the season. For example, Sunny's Superstars to have 0 points on Tuesday, 9 November 2010, 5 points on Wednesday, 10 November 2010 then 9 points on Saturday, 13 November 2010 (as it's a cumulative total going forward). The points for each player are shown under the cell "pts". Can this be done directly from the data or do I need to use formulas to set up the data?
    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