Thread: Creating a stacked column chart with percentage in the graph

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!

Sorry ,Graph should be :
X - axis: Class Name
Y - axis: No of students
In each line of the class should reflect the percentage of each grade for
each unit



"MQ" wrote:

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

Sounds like you want a stacked chart, not a stacked 100% chart. For the
labels, calculate them in a nearby range, then use one of these Excel
add-ins to apply labels from this range to the chart series:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

They're both free and easy to use.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"MQ" <MQ@discussions.microsoft.com> wrote in message
news:C95E707B-6338-4C5F-A44A-BDA009A6A89D@microsoft.com...
> Sorry ,Graph should be :
> X - axis: Class Name
> Y - axis: No of students
> In each line of the class should reflect the percentage of each grade for
> each unit
>
>
>
> "MQ" wrote:
>
>> 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!

Hi Jon,

Thanks for your advise.

"Jon Peltier" wrote:

> Sounds like you want a stacked chart, not a stacked 100% chart. For the
> labels, calculate them in a nearby range, then use one of these Excel
> add-ins to apply labels from this range to the chart series:
>
> Rob Bovey's Chart Labeler, http://appspro.com
> John Walkenbach's Chart Tools, http://j-walk.com
>
> They're both free and easy to use.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services - Tutorials and Custom Solutions -
> http://PeltierTech.com/
> 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
> http://peltiertech.com/Excel/ExcelUserConf06.html
> _______
>
> "MQ" <MQ@discussions.microsoft.com> wrote in message
> news:C95E707B-6338-4C5F-A44A-BDA009A6A89D@microsoft.com...
> > Sorry ,Graph should be :
> > X - axis: Class Name
> > Y - axis: No of students
> > In each line of the class should reflect the percentage of each grade for
> > each unit
> >
> >
> >
> > "MQ" wrote:
> >
> >> 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!
>
>
>

I am trying to create a similar chart. Can someone help me

Originally Posted by MQ

Hi Jon,

Thanks for your advise.

"Jon Peltier" wrote:

> Sounds like you want a stacked chart, not a stacked 100% chart. For the
> labels, calculate them in a nearby range, then use one of these Excel
> add-ins to apply labels from this range to the chart series:
>
> Rob Bovey's Chart Labeler, http://appspro.com
> John Walkenbach's Chart Tools, http://j-walk.com
>
> They're both free and easy to use.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services - Tutorials and Custom Solutions -
> http://PeltierTech.com/
> 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
> http://peltiertech.com/Excel/ExcelUserConf06.html
> _______
>
> "MQ" <MQ@discussions.microsoft.com> wrote in message
> news:C95E707B-6338-4C5F-A44A-BDA009A6A89D@microsoft.com...
> > Sorry ,Graph should be :
> > X - axis: Class Name
> > Y - axis: No of students
> > In each line of the class should reflect the percentage of each grade for
> > each unit
> >
> >
> >
> > "MQ" wrote:
> >
> >> 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!
>
>
>