Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have retrieve this result (pivot table) from my raw data:
---------------------+----------+ Count of student | Grade | ---------------------+----------+----------+-----------------+ Class | 1 | 2 | Grand Total | ---------------------+----------+----------+-----------------+ A | 5 | 4 | 9 | ---------------------+----------+----------+-----------------+ B | 2 | 3 | 5 | ---------------------+----------+----------+-----------------+ C | 5 | 3 | 8 | ---------------------+----------+----------+-----------------+ If I would like to create a stacked column chart with 100% for each class but the y-axis 's value should be the as the number of students, may I know if there is any way that i can create this? percentage is calculated using (Grand Total / grade) , example: for Class C, grade 1: Percentage will be: (5/8) * 100 = 62.5% Graph should be : X - axis: Unit Name Y - axis: No of users In each line of the units should reflect the percentage of each grade for each unit Appreciate any advises! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
Stacked column and cluster column on same chart? | Charts and Charting in Excel | |||
Can I setup mixed bar chart where last column is stacked? | Charts and Charting in Excel | |||
graph to compare one column with 2 others that are stacked | Excel Discussion (Misc queries) | |||
Making Special "Stacked Column" Chart | Charts and Charting in Excel |