Creating Line Chart From Data

**sun815613** · 11-30-2010, 07:51 AM

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?

**6StringJazzer** · 11-30-2010, 01:41 PM

You will have to set up the data to be more graph friendly. You can create another worksheet summarizing the data in a way that will be easy to chart. I have done that for you in the attached. I didn't see the pattern to what dates you are using; my data is set up to use just the dates you have.

I didn't create any charts but let us know if you need help with that part.

The one improvement I would recommend is that you change your dates in column B to be dates. They are currently text. That would make a lot of things easier here.

**sun815613** · 11-30-2010, 04:35 PM

I had a feeling I may have had to extract the data to another sheet. This is great, I'll make some changes on the original sheet to accommodate the dates and use the formulas you've given. The dates are when English Premier League Football matches take place, so no real set pattern there.

I'll give the chart a go and hopefully should be ok with that, if not I'll drop you line.

Many thanks for the help and guidance.

Regards,
Sunil.