Running Total Chart question

  • Thread starter Thread starter Neil Grantham
  • Start date Start date
N

Neil Grantham

I can create a chart that shows a running total of scores if I put
them in a column, but would link to do this with the scores across a
row.
However, if I do this and pick a Line graph, I get a line that just
shows peaks and troughs rather than a steady running total.

Example data

Player A 5 6 2 1 0 2 4 5 (The last cell is then the Total
score over the season - a SUM of the values, but not needed on the
chart)


So rather than the Graph's Y Axis showing a range of 0 to 8, it should
show 0 to whatever the Total is, and the X axis will be number of
matches.
The line I want is one that maps point 1 as 5, point 2 as 11, 3 as 13,
4 as 14, 5 also as 14, 6 is then 16 and so on.

Can it be done. I'm sure it can and I just can't see it!
Thanks
Neil
 
In another row, calculate the running totals, and create the chart from
that data.

For example, if Player A data starts in B2, enter the following formula
in B8: =SUM($B2:B2)
and copy the formula across to I8.
 
Yes! I could, but not really what I want, unless I hide those rows.
I want a series of rows showing competitors scores over a season, and
a chart to show points progress.

Any other ideas anyone?
Thanks
Neil
 
The best way to get around this problem is to use the Pivot Chart, and
in the data field, use the "show data as a running total"

This will give you a cumulative total and you can then chart them as a
running total in line format (or however you want)
 
So, what's the problem with hiding rows? Given that XL has 65536 rows
and, it's not like there will be a shortage of them, is there? In
addition, you could always put the cumulative data on a separate
worksheet.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
And you can set the chart to move but not resize with the cells:
deselect the chart, then select it with the Shift key depressed. Now
double click on it and check the appropriate option on the Properties tab.

- Jon
 
In this type of calculation is there any need to distinguish between
the case when the player plays and scores zero points and
the case when the player scores zero points because they didn't play?

Nev.


"Neil Grantham" wrote ...
 
Back
Top