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.