If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Running Total Chart question
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 |
#3
|
|||
|
|||
Running Total Chart question
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 |
#4
|
|||
|
|||
Running Total Chart question
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/ |
#5
|
|||
|
|||
Running Total Chart question
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 |
#6
|
|||
|
|||
Running Total Chart question
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. |
#7
|
|||
|
|||
Running Total Chart question
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. |
Thread Tools | |
Display Modes | |
|
|