Running Total Chart question

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.



Neil Grantham wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Debra Dalgleish wrote in message ...
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.



Neil Grantham wrote:
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

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)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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

In article , neil40
@btinternet.com says...
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

Debra Dalgleish wrote in message ...
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.



Neil Grantham wrote:
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

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Tushar Mehta wrote:
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.

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 ...
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.