Possible? Raw # Graph data w/ % labels??

Greetings!

I am wondering if this is possible or not- I have a table of raw data that I have made a line and bar graph from...What I would like to do is keep the graphs as they are (with the y-axis based on the actual raw data numbers), but then instead of the data labels reflecting that actual raw number as they currently do, I'd like it to reflect what percentage that raw number represents out of the grand total...clear as mud?

Any idea if this is possible?

Thanks so much for the help! I have attached a sample of the data in case that helps!!

Try this macro

Sub Test()
Dim MyChart As Chart
For N = 1 To ActiveSheet.ChartObjects.Count
    Set MyChart = ActiveSheet.ChartObjects(N).Chart
    For M = 1 To MyChart.SeriesCollection.Count
        For P = 1 To MyChart.SeriesCollection(M).Points.Count
            MyChart.SeriesCollection(M).Points(P).DataLabel.Text = Int(Cells(M + 1, P + 2) * 100 / Cells(15, P + 2)) & "%"
        Next P
    Next M
Next N
End Sub

OK.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007.