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
|
|||
|
|||
Calclulating percentages
Hi
I am creating a bat chart which will show a total score of e.g. 77%. I need to know how to work out how to show the part 6 components play towards this 77%. The six components are 83, 96, 84, 49, 35 and 64. How can I calulate this to show on chart please? |
#2
|
|||
|
|||
Calclulating percentages
Hello,
One option assumes the "total" score of 77% is really a target or average. Set the data up like below and then build a combination column - line chart. Series 1 would be your column source and series 2 would be the line source. If a single score is better than 77%, the column tied to that score will exceed the line. Series 1 Series 2 83 77 96 77 84 77 49 77 35 77 64 77 -- John Mansfield http://www.cellmatrix.net "SJL" wrote: Hi I am creating a bat chart which will show a total score of e.g. 77%. I need to know how to work out how to show the part 6 components play towards this 77%. The six components are 83, 96, 84, 49, 35 and 64. How can I calulate this to show on chart please? |
Thread Tools | |
Display Modes | |
|
|