Assuming the setup below where the columns labeled "a" and "b" are your
original data, add two additional columns to compute your percentages. Your
spreadsheet should look like this:

a b c d
a 4 6 40% 60%
b 2 4 33% 67%
c 3 5 38% 63%
d 4 3 57% 43%
e 6 2 75% 25%
f 5 5 50% 50%

Build you chart based on the first three columns. Do not refer to the
columns labeled "c" or "d" when you build the chart. These columns will be
used for data labeling purposes only.

Once your chart is built, you will need a tool such as Rob Bovey's XY Chart
Labeler

http://www.appspro.com/Utilities/ChartLabeler.htm

or John Walkenbach's Chart Tools

http://j-walk.com/ss/excel/files/charttools.htm

to add the % labels to your chart. Alternatively, you can use the following
macro:

Sub AddLabels()
Dim RngLabels As Range
Dim Ser As Series
Dim i As Long
If TypeName(Selection) = "Series" Then
Set Ser = Selection
Set RngLabels = Application.InputBox(prompt:="Select the label
range:", Type:=8)
Ser.HasDataLabels = True
For i = 1 To Ser.Points.Count
Ser.Points(i).DataLabel.Text = RngLabels(i)
Next i
Else
MsgBox "Select a series in a chart."
End If
End Sub

Add the macro to a standard module. Click on one of the chart series once.
Then, run the macro. The macro will prompt you for a data range. Enter the
range of percentages that you want to go with the series that you have
selected. When complete all you need to do is format the data that has been
added to the chart as a percentage.

----
Regards,
John Mansfield
http://www.pdbook.com




"kafoury123" wrote:

i have two data series that i want to represent as a stacked 3d column, i
want the percentage of each out of the total column height to be shown but
the data series option for percentage check mark is not active??!! why is
this and how can i add the percntage to the value?..please help